Hello Everyone,
The formula results in a #VALUE! error and it should result in a blank cell: It did result in a blank cell but when I added *(EK97/EK89) it was in error.
=IF(EK50>32,"",VLOOKUP(EK50,'Low Intensity Pace Chart'!$D$153:$E$185,2,FALSE))*(EK97/EK89)
Cell EK50 = 40
When cell EK50 <=32, the formula works.
Thank you!
Patrick
delivers #VALUE!
Please Login or Register to view this content.
It's because you're trying to multiply a text string and a number (and then divide by another number).
Change the "" to 0 or something.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
You have it this way, doing the math on the result of the IF, which may be a ""
=IF(EK50>32,"",VLOOKUP(EK50,'Low Intensity Pace Chart'!$D$153:$E$185,2,FALSE))*(EK97/EK89)
"" is not really blank, it's an empty TEXT string.
Text*Number=#Value!
Instead, Do the math on the result of the VLOOKUP, not on the result of the IF.
=IF(EK50>32,"",VLOOKUP(EK50,'Low Intensity Pace Chart'!$D$153:$E$185,2,FALSE)*(EK97/EK89))
JONMO1,
Your solution worked! I had one parenthesis in the wrong place!
And thanks to ben_hensel for your contribution as well.
Thank you!
Patrick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks