Good with excel equations?!?!?! Help me out!! :)

[BanamexDF]

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!!!!:cool:

[RavinJetta]

You really shouldn't be getting any of those #n/a for the sum's even if you don't have anything in them. I have tons of those on all my sheets and they just show zero or blank.

[oc-audica]

probably way off below but ravinjetta had a point... the cell should be blank if there is no data for the formula.

make sure the cells are 'formatted' as 'general'... perhaps?

[RavinJetta]

If you want you can send me the excel and I can take a look at it. I work with this stuff all day long.

[idrivea2002golf]

what if you put a 0 as the input? the computer might be taking the empty box as an infinite input giving you an infinite loop error?

[BanamexDF]

Thanks for your help guys. Ravin, I sent you a PM.

All the cells are interlinked, so unless the cells have a value, they show the error. I need it so even though the cells are empty, they don't show anything.

I HATE my IDS class. Teacher doesn't show us how to do the assignment until the day it's due when everyone is asking questions. And doesn't allow much time to do it either!! :tdown:

[BanamexDF]

YAY!!!!!!!!! I figured it out. I knew it wasn't going to be that hard.

In case you care, the new equations:

=IF(ISNA(VLOOKUP((A8),B47:C57,2)),"",(VLOOKUP((A8),B47:C57,2)))

=IF(A8=0,"",C8*D8)

=SUM(E8:E13)

=E14*C59

=SUM(E14:E15)-E16

Thanks for your responses guys.