I am trying to do an Excel formula to return one of four values in a particular cell.?

Question

I have a spreadsheet that I'm trying to do a formula in to return a certian value in a cell, once data is inputted in a different cell. So lets say the user enters SINGLE in cell A1. I want it to return a certain value. But, if they enter 2 WIDE in A1, I want it to return a different value, and if 3 WIDE is entered a different value. What is my best way to go about this?

Answer 1

B1 =IF(A1="Single",value1, IF(A1="2 Wide",value2, IF(A1="3 Wide",value3, "Wrong data")

Answer 2

You can combine + operator with IF operator



Its Formula will be like this:





= IF( A1="SINGLE"; 100; 0) + IF( A1="2 WIDE"; 150; 0) + IF( A1="3 WIDE"; 200; 0)

Answer 3

there is no thank you to question a cellular to ascertain if it good factors a formula, i.e. you will no longer have the potential to jot down an IF formula that checks if yet yet another cellular good factors a formula. regrettably Excel seems on the cost in a cellular extremely than the underlying formula, mutually as appropriate. the closest ingredient you're in a position to do is Edit | bypass to, then click on specific, then %. formula. you additionally can press F5 or CTRL+G to get admission to the bypass to verbal exchange. If Edit | bypass to isn't suited, then a macro (in VBA) might desire to do it utilizing the Hasformula factors yet i will grant no extra suitable help on that on condition that i do now no longer write VBA.