Hi, I am trying to use the IF formula for some data. I want to designate them based on their grand total. If its within a certain range then it would be designated 1, 2. or 3. 1 being the highest.
For numbers around 50-70 I am getting an error. Here is the formula.
Grand Total =54
=IF(AK13<10,"3",IF(AK13>60,"2",IF(AK13>75,"1")))
So what are the ranges as any value betwee 10 and 60 is not included in the formula
And remove quotes around the numbers as they will treated as TEXT : 3 vs "3"
76 will result in 2 as it passes the ">60" test!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The ranges are 1-1000 essentially.
If the number is less than or equal to 10 then it will be 3.
IF the number is greater than 10 but less than 60 then it will be 2.
If the number is greater than 75 then it will be 1.
How would I make it for this?
=IF(AK13<=10,3,if(AK13<60,2,if(AK>75,1,"out of range")
so between 60 and 75 "out of range"
What result you expect with a number between 60 and 75?
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks