I can’t figure out quite how to get Excel to do what I want. I am trying to create an IF function for the following situation. I have a cell, A1, with a value under 1. I would like another cell to display the following:
if A1 <= .001, then B1 = ***
if .001 < A1 <= .01, then B1 = **
if .01 < A1 < =.05, then B1 = *
if .05 < A1, then B1 = [blank]
What do I type in B1 to make it spit that out?
Thanks!
=if(A1<=0.001,“",if(A1<=0.01,"",if(A1<=0.05,"”,"")))
I’m sure others will give similar answers simultaneously.
Try ending with double quotes e.g = “”
Usually you put text in between the quote, like “OK”, but if you leave out text excel will return a blank. (I think formulas that check for blanks will not count it as a blank though)
Also, that’s a lot of nested IF statements. I pity anyone who has to double check your work.
Hope that helps.
(i.e. use the nested statement that mcgato posted)
Gah, you beat me to it, mcgato!
BetsQ, you have to use nested IF statements to do that in Excel.
IF(logical test, value if true, value if false).
So inside your first IF, include another IF statement as the ‘value is false’ portion.
Y’all rock. Thank you.
Indeed. It’s nested If functions. They’re sometimes easier to write from the inside-out than outside-in. Make it say “If A is this, display that, but if not, run the next If function.”