Greater than Formula

April 12, 2011 at 15:21:11
Specs: Windows Vista
I am trying to create a formula that basically states if a cell is >1 "normal" >5 "good" >10 "perfect" well or at least something along those lines..

See More: Greater than Formula

Report •

#1
April 12, 2011 at 15:25:31
Test from top down.

Report •

#2
April 12, 2011 at 15:32:44
Try:

=IF(A1>=10,"Perfect",IF(A1>=5,"Good",IF(A1>=1,"Normal","")))

MIKE

http://www.skeptic.com/


Report •

#3
April 12, 2011 at 15:46:34
I am still having issues.. tried both ways, I could get it to say everything was perfect.. even if it wasnt.. =]

Report •

Related Solutions

#4
April 12, 2011 at 15:57:49
The formula does what you requested.

If you have other requirements, then a full and clear request would help.

MIKE

http://www.skeptic.com/


Report •

#5
April 12, 2011 at 16:21:51
Mike,

Thank you for your help! Been a long day and I forgot a really small but vital step when doing the formula. It did work. Your the best!


Report •

Ask Question