LinkBack URL
About LinkBacks
Ill make this as simple as possible.
I have 4 cells, in Columns D, E, F, and G each showing the result of a VLookup
What I want to achieve in Column H is simply D14*((E14+F14)-G14)
Any suggestions?
Cheers,
Matt
Ill make this as simple as possible.
I have 4 cells, in Columns D, E, F, and G each showing the result of a VLookup
What I want to achieve in Column H is simply D14*((E14+F14)-G14)
Any suggestions?
Cheers,
Matt
Matt
Can't you just put this in column H?
=D14*((E14+F14)-G14)
If posting code please use code tags, see here.
Would you please provide the excel sheet
Agree with Norie, have you tried to use that formula in the cell yet? The fact that the references come from a formula (any formula) wont affect the results
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I figured it out, sort of. I don't really understand why, but changing one of the VLookups to show a zero instead of a blank fixed the issue. Ill leave that one alone now!
If you're talking about a formula blank ""...Originally Posted by MattKoleczko
That's a TEXT value and trying to do a math operation on a TEXT value will generate the #VALUE! error.
For example:
A1 = ""
B1 = 10
=A1+B1 = #VALUE!
One way to get around it is:
=SUM(A1,B1)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks