formula question

[hhamlinwright08]

Hi all,

How would I modify the formula below so that if S16 is "0" then the default cell value is automatically 0?

=IF(S16>0,(SUM(U16,X16,AA16,AD16,AG16,AJ16,AM16,AP16,AS16,AV16,AY16,BB16)/62),"")

Thanks in advance

 

[dw_73]

I assume by "default cell value" you mean the cell in which this formula sits?

If the sum cannot be less than zero then you could just replace the "" with a zero.

 

[footoo]

What do you want to return if S16 is blank?

 

[hhamlinwright08]

=IF(S184>0,(SUM(U184,X184,AA184,AD184,AG184,AJ184,AM184,AP184,AS184,AV184,AY184,BB184)/62),"0")

That did it! Thanks!

 

[dw_73]

=IF(S184>0,(SUM(U184,X184,AA184,AD184,AG184,AJ184,AM184,AP184,AS184,AV184,AY184,BB184)/62),"0")

That did it! Thanks!

If you leave the quote marks around the zero you won't be able to use the 0 in any other calculations as it will get entered as text. Just put in a zero with no quotes to have a zero number in the cell.