Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula - evaluation shows it should work but...
My formula is:
=IF(B2=1,"",(v2+z2+ad2+af2)) (B2 is either 0 or 1) However, this gives a blank result for every cell, even when B#=0. When I evaluate the formula through formula auditing the evaluation shows the formula should work. Am stumped! I have tried to re work the formula in several ways, if turned around (B#=0,(#+#+#), "") it inserts the summed value in every cell and none are blank even if (for example) B43=0 Hope you can help Juliet |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula - evaluation shows it should work but...
Is B2 formatted as TEXT? It shouldn't be.
"Juliet" wrote in message ... My formula is: =IF(B2=1,"",(v2+z2+ad2+af2)) (B2 is either 0 or 1) However, this gives a blank result for every cell, even when B#=0. When I evaluate the formula through formula auditing the evaluation shows the formula should work. Am stumped! I have tried to re work the formula in several ways, if turned around (B#=0,(#+#+#), "") it inserts the summed value in every cell and none are blank even if (for example) B43=0 Hope you can help Juliet |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula - evaluation shows it should work but...
Thanks Barb,
the worksheet is in general numerical format, can I assume then that the formula entered is numerical too and not text? juliet "Barb Reinhardt" wrote: Is B2 formatted as TEXT? It shouldn't be. "Juliet" wrote in message ... My formula is: =IF(B2=1,"",(v2+z2+ad2+af2)) (B2 is either 0 or 1) However, this gives a blank result for every cell, even when B#=0. When I evaluate the formula through formula auditing the evaluation shows the formula should work. Am stumped! I have tried to re work the formula in several ways, if turned around (B#=0,(#+#+#), "") it inserts the summed value in every cell and none are blank even if (for example) B43=0 Hope you can help Juliet |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula - evaluation shows it should work but...
You need to check that B2 is not formatted as Text - select B2 and
Format | Cells | Number (tab) - what format type is displayed? If it Text then click General and OK. Double-click B2 for the change to take place. You might also check that B2 contains the number 1 and not the "text" value '1. Hope this helps. Pete |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula - evaluation shows it should work but...
Hi Julie
If the formula evaluation tool returns the correct result, then it sounds as though calculation may be set to manual. Try pressing F9 and see what happens. If required ToolsOptionsCalculationAutomatic -- Regards Roger Govier "Juliet" wrote in message ... Thanks Barb, the worksheet is in general numerical format, can I assume then that the formula entered is numerical too and not text? juliet "Barb Reinhardt" wrote: Is B2 formatted as TEXT? It shouldn't be. "Juliet" wrote in message ... My formula is: =IF(B2=1,"",(v2+z2+ad2+af2)) (B2 is either 0 or 1) However, this gives a blank result for every cell, even when B#=0. When I evaluate the formula through formula auditing the evaluation shows the formula should work. Am stumped! I have tried to re work the formula in several ways, if turned around (B#=0,(#+#+#), "") it inserts the summed value in every cell and none are blank even if (for example) B43=0 Hope you can help Juliet |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula - evaluation shows it should work but...
Hello Juliet...
Could you please state what occupies those cells : (v2+z2+ad2+af2) ? I see nothing wrong with the syntax of your IF formula, so I'm suspecting the problem lies in those four cells. Thank you... Roger H. "Juliet" wrote in message ... My formula is: =IF(B2=1,"",(v2+z2+ad2+af2)) (B2 is either 0 or 1) However, this gives a blank result for every cell, even when B#=0. When I evaluate the formula through formula auditing the evaluation shows the formula should work. Am stumped! I have tried to re work the formula in several ways, if turned around (B#=0,(#+#+#), "") it inserts the summed value in every cell and none are blank even if (for example) B43=0 Hope you can help Juliet |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula - evaluation shows it should work but...
Another possibility to add to the previous answers:
Is B1 a calculated result? it may be displaying 1 but be some value slightly different - even off by 0.00000000001 would cause the test B2=1 to fail. Try just =IF(B2,"",(v2+z2+ad2+af2)) -- HTH Sandy with @tiscali.co.uk "Juliet" wrote in message ... My formula is: =IF(B2=1,"",(v2+z2+ad2+af2)) (B2 is either 0 or 1) However, this gives a blank result for every cell, even when B#=0. When I evaluate the formula through formula auditing the evaluation shows the formula should work. Am stumped! I have tried to re work the formula in several ways, if turned around (B#=0,(#+#+#), "") it inserts the summed value in every cell and none are blank even if (for example) B43=0 Hope you can help Juliet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making this formula work | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |