My IF in Excel formula is not returning the correct value.
Steph, not sure what you are doing, I can put =A1+A2+A3 in cell G29, or
something else and as long as the formula comes up with 1,2,or 3 the message
is displayed. As Bearacade asked what is in cell G29, and maybe how it is
formatted, could be showing 1,2,or 3 but the answer may be something like
2.1?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Steph" wrote in message
...
Thank you Paul that helped some what. I am still having a problem.
Picture
a performance review with a row of 1,2,3 as the points for each cell. At
the
end the points are all added up and an overall rating is calculated 1,2,
or
3. If I key in all 1 the value = does not meet, however if I populate the
fields 1, 2, or 3 randomly the value is false or blank with what you
proposed. But I was thinking it should not matter what get's me to the
cell
that I am referencing as long as it equals 1,2,3. Your thoughts?
"Steph" wrote:
I am doing a reference of 1, 2, or 3 returning specific text based on
the
number. Here is my formula.
=IF(G29=1,"DOES NOT MEET",IF(G29=2,"CONSISTENTLY
MEETS",IF(G29=3,"EXCEEDS")))
if the ratings are all 3's the correct text value will appear. If you
vary
the ratings I receive a false value. Can anyone help me.
|