formula to return blank cell - IF function

**n1kk1** · 12-17-2009, 07:11 AM

Hi, I have an IF formula in the attached, what I need is for it to return a blank cell if it returns 0, or in the case of Dates - 0 Jan 00 (which is the default date it brings up)

Can anyone help?

many thanks

**DonkeyOte** · 12-17-2009, 07:16 AM

To avoid double iteration just use a Custom Format on the cells in question, eg: [=0]"";d mmm yy

Same principle can be applied to other cells - simply alter the other format that is required based on data type, eg (assuming positive commission only): [=0]"";0.00

does that help ?

**teylyn** · 12-17-2009, 07:17 AM

Hi, you need to check your condition. All your formulas evaluate the FALSE part of the IF() statement.

I don't quite understand what you are testing with your condition, so maybe you could explain?