I'm having some trouble getting the proper syntax for the following:
CELL D5 will have a value in it.
Based on the value in CELL D5, CELL E5 will have the following:
IF D5 > 1 and D5 <= 1.25 then CELL E5 = "Good"
IF D5 > 1.25 and D5 <= 3 then CELL E5 = "Better"
IF D5 = 3 then CELL E5 = "Best"
IF D5 > 3 then CELL E5 = "Not Capable"
Wish I didn't know now what I didn't know then.
Hi
=IF(AND(D5>1,D5<=1,25),"Good",IF(AND(D5>1,25,D5<3),"Better",IF(D5=3;"Best",IF(D5>3,"Not Capable"))))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks...that needed a little editing but it works. Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks