|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 22nd, 2004, 07:25 PM
|
|||
|
|||
IF Function
Here is a nice easy one! I have a value in a spreadsheet that I need to check. If the value -0.005% or 0.005%, then I need to notify the user that an adjustment is required. I tried this =IF(C27-0.0049999,"adj required",(IF(C270.0049999,"adj required","no adj required"))) but alas it doesn't work. Can anyone help? Thanks Simon -- sgrech ------------------------------------------------------------------------ sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501 View this thread: http://www.excelforum.com/showthread...hreadid=271631 
|
|
#2
October 22nd, 2004, 07:36 PM
|
|||
|
|||
|
Try... =IF(A1"",IF(ABS(A1)0.005%,"Adjustment Required","No Adjustment Required"),"") Hope this helps! sgrech Wrote: Here is a nice easy one! I have a value in a spreadsheet that I need to check. If the value -0.005% or 0.005%, then I need to notify the user that an adjustment is required. I tried this =IF(C27-0.0049999,"adj required",(IF(C270.0049999,"adj required","no adj required"))) but alas it doesn't work. Can anyone help? Thanks Simon -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=271631
|
|
#3
October 22nd, 2004, 09:31 PM
|
|||
|
|||
|
Have you tried using "Validation" under the Data menu?
"sgrech" wrote: Here is a nice easy one! I have a value in a spreadsheet that I need to check. If the value -0.005% or 0.005%, then I need to notify the user that an adjustment is required. I tried this =IF(C27-0.0049999,"adj required",(IF(C270.0049999,"adj required","no adj required"))) but alas it doesn't work. Can anyone help? Thanks Simon -- sgrech ------------------------------------------------------------------------ sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501 View this thread: http://www.excelforum.com/showthread...hreadid=271631
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| continuous form | PeterM | General Discussion | 8 | October 20th, 2004 05:59 AM |
| #Error using function as controlsource | Laurel | New Users | 4 | September 24th, 2004 08:31 PM |
| Newbe help - VBA function | Kristen | Worksheet Functions | 2 | April 21st, 2004 10:30 PM |
| Customising the Function Wizard | Frank Kabel | Worksheet Functions | 1 | April 20th, 2004 06:46 PM |
| Function for % gain? | Norman Harker | Worksheet Functions | 4 | April 1st, 2004 11:54 AM |
Linear Mode
