Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA NOT WORKING
here's my formula
=IF(AND($D70,$L7<($E7-$F7),$AV7=AW7),AW7,"NO") Argument 1 is true - D7 is greater than 0 Argument 2 is false - L7 is equal to E7-F7 Argument 3 is true €“ AV7 is greater than AW 7 Still €“ the formula is returning AW7 instead of NO HELP!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA NOT WORKING
Hi,
With the 3 conditions you note the formula returns NO for me so I suggest you check your data. Are they really number? Are the numbers smaller/larger than you think they are because formatting is changing the way you are seeing them? Mike "Gator Girl" wrote: here's my formula =IF(AND($D70,$L7<($E7-$F7),$AV7=AW7),AW7,"NO") Argument 1 is true - D7 is greater than 0 Argument 2 is false - L7 is equal to E7-F7 Argument 3 is true €“ AV7 is greater than AW 7 Still €“ the formula is returning AW7 instead of NO HELP!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA NOT WORKING
Hi, Mike. Thanks for responding.
I started playing - it seems that the "culprit" is $L7<($E7-$F7). All three cells are formatted as "accounting". L7 has no formula. E7 has no formula. F7 does ....=IF(E70,((E7-500)*0.015)+15,0) If I put this formula in L7 ........=E7-F7...., then the formula in M7 works - but I can't put a formula in L7 because it isn't ALWAYS E7-F7. "Mike H" wrote: Hi, With the 3 conditions you note the formula returns NO for me so I suggest you check your data. Are they really number? Are the numbers smaller/larger than you think they are because formatting is changing the way you are seeing them? Mike "Gator Girl" wrote: here's my formula =IF(AND($D70,$L7<($E7-$F7),$AV7=AW7),AW7,"NO") Argument 1 is true - D7 is greater than 0 Argument 2 is false - L7 is equal to E7-F7 Argument 3 is true €“ AV7 is greater than AW 7 Still €“ the formula is returning AW7 instead of NO HELP!!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULA NOT WORKING
Try this: increase all three cells to 4 decimal places and see which
is actually bigger. One of your cells probably is not exactly what you think due to the number of decimal places in formatting. Maybe you need to add a Round function to your formula to force a certain number of decimal places, I'm assuming 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working an If formula | Excel Worksheet Functions | |||
formula not working | New Users to Excel | |||
Formula not working | Excel Worksheet Functions | |||
Formula Sometimes Working Sometimes Not | Excel Discussion (Misc queries) | |||
Formula not working | Excel Discussion (Misc queries) |