I am using this formula which is working fine, but I also want the cell to be blank and not show FALSE when the reference cell of E10 is empty.
=IF(E10="A",".26",IF(E10="B",".50",IF(E10="C",".15",IF(E10="D",".32",IF(E10="E",".60",IF(E10="F",".41"))))))
Please Login or Register to view this content.
Try
=IFERROR(LOOKUP(E10,{"A","B","C","D","E","F"},{0.26,0.5,0.15,0.32,0.6,0.41}),"")
Life's a spreadsheet, Excel!
Say thanks, Click *
This one worked, thank you.
Or tryPlease Login or Register to view this content.
Hi and welcome to the forum
If the "0.26", ".50" etc are meant to be values, you dont need to use "" In fact, wrapping a number in "" converts it to text, and it cannot be used (as is) in a calc. You would be better to remove them...
=IF(E10="A",.26,IF(E10="B",.50,IF(E10="C",.15,IF(E10="D",.32,IF(E10="E",.60,IF(E10="F",.41,""))))))
Also, if you have many more options to choose from, you may be better off creating small table with criteria and values, and then using vlookup to find what you want
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks