Hey, I'm doing an excel project and have all my equations figured out but now I'm stuck with the "#N/A" when cells don't have anything in them. Could you guys tell me how I could rewrite these equations so I don't get the error when the cells are blank?
Equations:
=IF(D8,C8*D8,"")
=SUM(E8:E13)
=E14*C59
=IF(E14>50,(E14*C60),"none")
=SUM(E14:E16)
I'll take a screen shot of my spread sheet if it will help when I get home. Thanks for any help!!!!
Equations:
=IF(D8,C8*D8,"")
=SUM(E8:E13)
=E14*C59
=IF(E14>50,(E14*C60),"none")
=SUM(E14:E16)
I'll take a screen shot of my spread sheet if it will help when I get home. Thanks for any help!!!!