If formula = 0

Deb T · Apr 3rd, 2002, 03:36 PM

I have a formula set up, but if the formula = 0, I do not want it to print the 0. How would I do that?

Mark W. · Apr 3rd, 2002, 03:40 PM

You could format the cell as...

General;-General;

brettvba · Apr 3rd, 2002, 03:45 PM

Or go to tools /options/ and uncheck zero values this will make it so it won't display zero values

daleyman · Apr 3rd, 2002, 03:49 PM

or if you want to show zeros elsewhere on the sheet, use an IF statement:

=IF(formula=0,"",formula)

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

Apr 3rd, 2002, 03:36 PM	#1
Deb T New Member Join Date: Apr 2002 Posts: 2	I have a formula set up, but if the formula = 0, I do not want it to print the 0. How would I do that?

Apr 3rd, 2002, 03:40 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You could format the cell as... General;-General;

Apr 3rd, 2002, 03:45 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Or go to tools /options/ and uncheck zero values this will make it so it won't display zero values

Apr 3rd, 2002, 03:49 PM	#4
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	or if you want to show zeros elsewhere on the sheet, use an IF statement: =IF(formula=0,"",formula)