Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN function help needed!!
I am trying to set up an IF-THEN function that will handle recognizing a
number between 2 other numbers and cannot seem to get it to work. My current formula looks like this: IF(27%<=AA16<=27.9%, round(M16*0.01,2),0) Can anyone help with this? Right now if I plug in 27.5% in cell AA16 I get 0. My goal is for this formula to calculate to the following answer: If AA16 = 27.5% If M16 = 46900 Answer = 469.00 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN function help needed!!
You could try this:
=IF(INT(AA16)=27,ROUND(M16*.01,2),0) This just checks the integer portion of the number in AA16. However, 27.91 would also be true in this case whereas your example would consider it false. If that's a problem, then try: =IF(AND(AA16=27,AA16<=27.9),ROUND(M16*.01,2),0) HTH, Elkar "Karen" wrote: I am trying to set up an IF-THEN function that will handle recognizing a number between 2 other numbers and cannot seem to get it to work. My current formula looks like this: IF(27%<=AA16<=27.9%, round(M16*0.01,2),0) Can anyone help with this? Right now if I plug in 27.5% in cell AA16 I get 0. My goal is for this formula to calculate to the following answer: If AA16 = 27.5% If M16 = 46900 Answer = 469.00 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN function help needed!!
"Elkar" wrote in message
... You could try this: =IF(INT(AA16)=27,ROUND(M16*.01,2),0) The Op's data was 27% so INT() will always return zero I would suggest: IF(FLOOR(AA16,1%)=27%,ROUND(M16*.01,2),0) -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Function Needed! Please Help! | Excel Worksheet Functions | |||
Help needed with function | Excel Worksheet Functions | |||
Desperate Help needed with a function. | Excel Worksheet Functions | |||
IF function help needed | Excel Worksheet Functions |