Blank formula fields

danielle · Mar 17th, 2002, 04:28 PM

I have the below IF statement in e.g. F1 where F1 should display the answer of B1 * E1.

=IF((B21*E21)>0,"","")

Now what I want is if the answer of B1 * E1 is greater than zero I want the answer to show. If the answer is zero I want the cell, in this case F1, to be blank.

Possible?

I can get the blank to show but then I can't get the answer to show.

Any ideas?

svmac · Mar 17th, 2002, 04:32 PM

Try:

IF((B21*E21)>0,(B21*E21),"")

danielle · Mar 17th, 2002, 04:58 PM

Thanks that formula worked. I originally had that formula but with "(B1*E1)" so the cell was actualloy showing up (B1*E1)!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 17th, 2002, 04:28 PM	#1
danielle New Member Join Date: Mar 2002 Location: Melbourne, Victoria Posts: 10	I have the below IF statement in e.g. F1 where F1 should display the answer of B1 * E1. =IF((B21E21)>0,"","") Now what I want is if the answer of B1 E1 is greater than zero I want the answer to show. If the answer is zero I want the cell, in this case F1, to be blank. Possible? I can get the blank to show but then I can't get the answer to show. Any ideas?

Mar 17th, 2002, 04:32 PM	#2
svmac Board Regular Join Date: Feb 2002 Location: Adelaide, Australia Posts: 182	Try: IF((B21E21)>0,(B21E21),"")

Mar 17th, 2002, 04:58 PM	#3
danielle New Member Join Date: Mar 2002 Location: Melbourne, Victoria Posts: 10	Thanks that formula worked. I originally had that formula but with "(B1E1)" so the cell was actualloy showing up (B1E1)!