#DIV/0!

[syeong]

I am aware that I can use the IF(ISERR.. function to stop the cell display this message, but I can see to get the cell to give a blank display when there is no value in D18,(the formula works OK). Any help will be appreciated.

=IF(ISERR(($C$9*(E18+F18))+($C$10*E18)+C18)/D18,"",(($C$9*(E18+F18))+($C$10*E18)+C18)/D18)

 

[PaddyD]

On 2002-09-23 18:59, syeong wrote:
I am aware that I can use the IF(ISERR.. function to stop the cell display this message, but I can see to get the cell to give a blank display when there is no value in D18,(the formula works OK). Any help will be appreciated.

=IF(ISERR(($C$9*(E18+F18))+($C$10*E18)+C18)/D18,"",(($C$9*(E18+F18))+($C$10*E18)+C18)/D18)

Hi - welcome to the board!

Not really sure what your question is, but if the above formula is working, you can shorten it to :

=IF(D18,(($C$9*(E18+F18))+($C$10*E18)+C18)/D18,"")

care to explain what you're after in a little more details?

Paddy

EDIT: typos
This message was edited by PaddyD on 2002-09-23 19:08

 

[syeong]

Thanks, The formula is based on calculated a unit cost for D18 cell, if D18 is blank (no data), the formula cell gives the #DIV/0!, I do not want this to be display.

 

[PaddyD]

have you tried the revised formula?

 

[syeong]

It works, and is less complicated. Thanks again, I have a lot to learn about making shorter formula for sure.