software

My formula is:

=IF(B2=1,quot;quot;,(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,(# # #), quot;quot;) it inserts the summed value in every cell and none are
blank even if (for example) B43=0

Hope you can help

Juliet

Is B2 formatted as TEXT? It shouldn't be.
quot;Julietquot; gt; wrote in message
...
gt; My formula is:
gt;
gt; =IF(B2=1,quot;quot;,(v2 z2 ad2 af2))
gt;
gt; (B2 is either 0 or 1)
gt;
gt; However, this gives a blank result for every cell, even when B#=0. When I
gt; evaluate the formula through formula auditing the evaluation shows the
gt; formula should work. Am stumped!
gt;
gt; I have tried to re work the formula in several ways, if turned around
gt; (B#=0,(# # #), quot;quot;) it inserts the summed value in every cell and none are
gt; blank even if (for example) B43=0
gt;
gt; Hope you can help
gt;
gt; Juliet
Thanks Barb,
the worksheet is in general numerical format, can I assume then that the
formula entered is numerical too and not text?
julietquot;Barb Reinhardtquot; wrote:

gt; Is B2 formatted as TEXT? It shouldn't be.
gt; quot;Julietquot; gt; wrote in message
gt; ...
gt; gt; My formula is:
gt; gt;
gt; gt; =IF(B2=1,quot;quot;,(v2 z2 ad2 af2))
gt; gt;
gt; gt; (B2 is either 0 or 1)
gt; gt;
gt; gt; However, this gives a blank result for every cell, even when B#=0. When I
gt; gt; evaluate the formula through formula auditing the evaluation shows the
gt; gt; formula should work. Am stumped!
gt; gt;
gt; gt; I have tried to re work the formula in several ways, if turned around
gt; gt; (B#=0,(# # #), quot;quot;) it inserts the summed value in every cell and none are
gt; gt; blank even if (for example) B43=0
gt; gt;
gt; gt; Hope you can help
gt; gt;
gt; gt; Juliet
gt;
gt;
gt;

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 quot;textquot;
value '1.

Hope this helps.

PeteHi 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 Toolsgt;Optionsgt;Calculationgt;Automatic

--
Regards

Roger Govierquot;Julietquot; gt; wrote in message
...
gt; Thanks Barb,
gt; the worksheet is in general numerical format, can I assume then that
gt; the
gt; formula entered is numerical too and not text?
gt; juliet
gt;
gt;
gt; quot;Barb Reinhardtquot; wrote:
gt;
gt;gt; Is B2 formatted as TEXT? It shouldn't be.
gt;gt; quot;Julietquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; My formula is:
gt;gt; gt;
gt;gt; gt; =IF(B2=1,quot;quot;,(v2 z2 ad2 af2))
gt;gt; gt;
gt;gt; gt; (B2 is either 0 or 1)
gt;gt; gt;
gt;gt; gt; However, this gives a blank result for every cell, even when B#=0.
gt;gt; gt; When I
gt;gt; gt; evaluate the formula through formula auditing the evaluation shows
gt;gt; gt; the
gt;gt; gt; formula should work. Am stumped!
gt;gt; gt;
gt;gt; gt; I have tried to re work the formula in several ways, if turned
gt;gt; gt; around
gt;gt; gt; (B#=0,(# # #), quot;quot;) it inserts the summed value in every cell and
gt;gt; gt; none are
gt;gt; gt; blank even if (for example) B43=0
gt;gt; gt;
gt;gt; gt; Hope you can help
gt;gt; gt;
gt;gt; gt; Juliet
gt;gt;
gt;gt;
gt;gt;
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.
quot;Julietquot; gt; wrote in message
...
gt; My formula is:
gt;
gt; =IF(B2=1,quot;quot;,(v2 z2 ad2 af2))
gt;
gt; (B2 is either 0 or 1)
gt;
gt; However, this gives a blank result for every cell, even when B#=0. When I
gt; evaluate the formula through formula auditing the evaluation shows the
gt; formula should work. Am stumped!
gt;
gt; I have tried to re work the formula in several ways, if turned around
gt; (B#=0,(# # #), quot;quot;) it inserts the summed value in every cell and none are
gt; blank even if (for example) B43=0
gt;
gt; Hope you can help
gt;
gt; Juliet
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,quot;quot;,(v2 z2 ad2 af2))

--
HTH

Sandy
with @tiscali.co.ukquot;Julietquot; gt; wrote in message
...
gt; My formula is:
gt;
gt; =IF(B2=1,quot;quot;,(v2 z2 ad2 af2))
gt;
gt; (B2 is either 0 or 1)
gt;
gt; However, this gives a blank result for every cell, even when B#=0. When I
gt; evaluate the formula through formula auditing the evaluation shows the
gt; formula should work. Am stumped!
gt;
gt; I have tried to re work the formula in several ways, if turned around
gt; (B#=0,(# # #), quot;quot;) it inserts the summed value in every cell and none are
gt; blank even if (for example) B43=0
gt;
gt; Hope you can help
gt;
gt; Juliet