IFS formula returns zero. How do I get the cell to remain blank?

[muad'ebe]

The formula I am using -

=IFS($AD$28=1,'Hourly Rates'!$C$7,$AD$28=2,'Hourly Rates'!$K$7,$AD$28=3,'Hourly Rates'!$S$7,$AD$28=4,'Hourly Rates'!$AA$7,$AD$28=11,'Hourly Rates'!$AI$7,$AD$28=12,'Hourly Rates'!$AQ$7,$AD$28=13,'Hourly Rates'!$AY$7,$AD$28=14,'Hourly Rates'!$BG$7)

Sometimes the returned value is zero, and is entered into the cell as "0". I would like the cell to remain blank when the value returned is zero. Does anyone know how to modify/add to the formula to leave the cell blank instead of having a zero in it? (when value retuned is zero)

Thank you!

 

[Gerald Higgins]

If you just want it to LOOK blank, then you can apply a special number format to the cell, which will make zero values appear blank.

 

[JamesCanale]

The easiest way would be to change the formatting of the cell, taking advantage of custom formatting:

0;-0;
for money:
$0.00;-$0.00;

 

[Fluff]

How about

=IFERROR(1/(1/IFS($AD$28=1,'Hourly Rates'!$C$7,$AD$28=2,'Hourly Rates'!$K$7,$AD$28=3,'Hourly Rates'!$S$7,$AD$28=4,'Hourly Rates'!$AA$7,$AD$28=11,'Hourly Rates'!$AI$7,$AD$28=12,'Hourly Rates'!$AQ$7,$AD$28=13,'Hourly Rates'!$AY$7,$AD$28=14,'Hourly Rates'!$BG$7)),"")

 

[muad'ebe]

How about

=IFERROR(1/(1/IFS($AD$28=1,'Hourly Rates'!$C$7,$AD$28=2,'Hourly Rates'!$K$7,$AD$28=3,'Hourly Rates'!$S$7,$AD$28=4,'Hourly Rates'!$AA$7,$AD$28=11,'Hourly Rates'!$AI$7,$AD$28=12,'Hourly Rates'!$AQ$7,$AD$28=13,'Hourly Rates'!$AY$7,$AD$28=14,'Hourly Rates'!$BG$7)),"")

Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.