Solved: #NA problem

[lacviet2005]

Hi guys,
I'm not an excel person, but sometimes I do need to use it. Anyway, I have a #NA issue here :banghead: . Please see attachment for a better idea.

If you have a better way to do it (without using macro), please show me. Very much appreciated.

Thank you all,
LV

[Bob Phillips]

Use

=(($G$8=1)*(CONVERT($C$8,"lbm","g")/1000)+($G$8=2)*(CONVERT($C$8*1000,"g","lbm")))

=(($G$8=1)*(CONVERT($C$8,"lbm","g")/1000)+($G$8=2)*(CONVERT($C$8*1000,"g","lbm")))*1.5

=(($G$8=1)*(CONVERT($C$8,"lbm","g")/1000)+($G$8=2)*(CONVERT($C$8*1000,"g","lbm")))*2

and you get an exact answer everytime, and no need for the table

[lacviet2005]

Wow, that is quick XLD.
Anyway, I try your formula and now I get #VALUE.

what did i do wrong here?
Thanks,
LV

[Bob Phillips]

What do you have in G8 and C8?

I plugged those formulae straight into your workbook and they worked fine.

[lacviet2005]

XLD - I have in G8 = 2 and C8 = 1.8
Is there anyway that you send the one that you have to me? Cuz it doesn't work for me.

Thanks so much for your help.

LV

[Aussiebear]

Try copying the formulas from XLD's post and pasting them into the relevant cells. This will eliminate any errors.

When I've done this, I get a correct result.

[Bob Phillips]

.

[lacviet2005]

Thanks so much XLD. :bow:

The reason it didn't work before because i didn't have the Analysis ToolPak add-ins on. After that, it works like a charm.


I have another question, are there any ways or methods to have the Analysis ToolPak turn on automatically? I guess it has to do with macro right? :whistle:


LV

[Aussiebear]

Once you have it turned on ( checked the option) its always available.

[mdmackillop]

You can also add/remove them for specific workbooks e.g.

Private Sub Workbook_Open()
AddIns("vbax KB Search").Installed = True
End Sub

[lacviet2005]

Thanks you guys.