Multi-result IF Statements...

[jacobswenson]

I am running a contest at work and I need a cell to return different values IF based on the returns results. For example the column header is "Current Reward" and I want it to return either "$500", "$750" or "$1,000" depending on the the data at specific value benchmanrks.

I know I am doing this wrong but this is what I have been trying: =IF(AND(K3>.25, K3<.3499, "$500":wink:)... and then I get stuck.

The results should return these truths: K3>.25 or <.3499 = "$500", BUT IF K3>.35 and <.4499 = "$750", BUT IF K3>.45 and <.7499 = "$1,000". Does that make any sense? Not sure where to turn for this one - couldn't find this type of problem on any of the threads... Please help!!

Jake

 

[FormR]

Hi, here is one possible option you can try that doesn't involve nesting IF() functions.

=LOOKUP(K3,{0,0.25,0.35,0.45,0.75},{0,500,750,1000,"Over.."})

 

[chicagocomputerclasses]

=VLOOKUP(K3,{0,"None";0.25,500;0.35,750;0.45,1000;0.75,"None"},2,1)