I cannot workout why my formula doesn't work and keeps returning 'false' . I have attached a copy of the spreadsheet which a questionnaire...
Thanks
I cannot workout why my formula doesn't work and keeps returning 'false' . I have attached a copy of the spreadsheet which a questionnaire...
Thanks
C7 contains a formula to convert the text number to an actual number, so then your IF formula should not contain quotes around the numbers....
Another way to write the formula:
=LOOKUP(C11,{0,2,3,4},{0,33,66,100})
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
HI Sallywg,
welcome to the forum.
Try using the below formula:-
Formula:Please Login or Register to view this content.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks