View Full Version : Solved: #NA problem
lacviet2005
04-19-2007, 03:30 PM
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
04-19-2007, 03:36 PM
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
04-19-2007, 03:50 PM
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
04-19-2007, 04:08 PM
What do you have in G8 and C8?
I plugged those formulae straight into your workbook and they worked fine.
lacviet2005
04-19-2007, 04:36 PM
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
04-19-2007, 11:59 PM
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
04-20-2007, 12:28 AM
.
lacviet2005
04-20-2007, 08:20 AM
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
04-20-2007, 11:58 AM
Once you have it turned on ( checked the option) its always available.
mdmackillop
04-20-2007, 02:02 PM
You can also add/remove them for specific workbooks e.g.
Private Sub Workbook_Open()
AddIns("vbax KB Search").Installed = True
End Sub
lacviet2005
04-20-2007, 04:42 PM
Thanks you guys.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.