LinkBack URL
About LinkBacks
EverClever 
Hello All,
=IF(C8="Lion",'Data Input'!B58*E15,0)
C8 is a drop down list with 12 choices
E15 = 2,005
'Data Input'!B58 = 60%
Correct answer = 1,203
My answer = 0
Thank you,
Patrick
Hello All,
=IF(C8="Lion",'Data Input'!B58*E15,0)
C8 is a drop down list with 12 choices
E15 = 2,005
'Data Input'!B58 = 60%
Correct answer = 1,203
My answer = 0
Thank you,
Patrick
First thing to check is the second bit of the formula. What does this bit return on its own?
'Data Input'!B58*E15
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi EverClever,
I'd bet either E15 or B58 is TEXT and not a number. If it is text then the value is equal to zero. See if that is the problem.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Further to Marvin's post, you can then try this:
VALUE('Data Input'!B58)*VALUE(E15)
Or the other possiblity is C8 in fact does NOT = Lion
Is this TRUE or FALSE
=C8="Lion"
Hey Jonmo,
Good guess
Because he said it was a dropdown, I assumed he wouldn't have a space after Lion or spelled it wrong, but you might be correct.
AliGW,
Just using the E15*'Data Input'!*B58 = #VALUE!
Your suggested formula returns the same error VALUE('Data Input'!B58)*VALUE(E15)= #VALUE!
MarvinP,
E15 or B58 is not TEXT
Jonmo1,
The dropdown list did have Lion selected
rather than playing guessing games...
Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).
1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.
2. Make sure that your desired solution is also shown (mock up the results manually).
3. Make sure that all confidential information is removed first!!
4. Try to avoid using merged cells. They cause lots of problems!
Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
That wasn't really what I was suggesting.The dropdown list did have Lion selected
Maybe the Lion in your dropdown is actually " Lion" or "Lion ", with a leading or trailing space.
Which is why I suggested this to test for sure.
=C8="Lion"
I uploaded the sample worksheet
Lion is indented 5 spaces so I changed to " Lion" and got a #VALUE! error
Hi EverClever,
Because there are so many millions of people who use Excel, I'd bet you are doing something different that what Excel Expects. I'm still believing that one of your two cells is Text and not a number. I've seen this many times. For example, have your tried an ISNUMBER function on your two values? Is the name of your other worksheet correct? Look for something that you are doing wrong and not that the IF function doesn't work. Change some things around and see what happens.
Last edited by MarvinP; 07-28-2017 at 02:25 PM.
1. Cahnge to "Lion" NO spaces and change the formula to
=IF(C9="Lion",E15*'Grading Scale'!B58,0)
ok, even with that corrected (C8 indeed does NOT = Lion)
I correct that in the book, and still get 0 because B58 is blank.
Blank is considered 0 so
E15*0 = 0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks