Is it necessary to use the IF function.........

[James Perry]

I have numeric values in columns A & B in about 200 rows.
Column C2 has the product of col A&B using a simple formula:
= A2*B2
Some cells in col A or col B or both are blank in which case col C will display a numeric zero.
But i prefer col C to display a 'blank' instead.
So i use the formula:
=IF(A2*B2>0,A2*B2,"")
Is it necessary to use the IF function only to get a blank in Col C ??
Or can the formula =A2*B2 be customised without having to use the IF function.

 

[Khalid NGO]

Hi James,

Try CF formula C2:
=AND(A2="",B2="")

use Custom Format ""

 

[AIM]

Hi James,

You can also use the following custom formatting for column C : 0;-0;;@

Regards!!!

 

[Khalid NGO]

Good one @AIM

Also single # can be used.

 

[James Perry]

Thank you. I'll settle for that.