| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula for displaying a message
Hi
If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Try:
=IF(AND(A180,A1<89),"abc",IF(AND(A1=90,A1<99),"d ef",IF(AND(A1100,A1<119),"ghi",""))) Micky "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Hi Sherees,
I am sure an expert can find a better formula, but until then you can try this: IF(A1<=79,"",IF(A1=80,"abc",IF(A1<=(90-1),"abc",IF(A1=90,"def",IF(A1<=(100-1),"def",IF(A1=100,"ghi",IF(A1<=(120-1),"ghi",""))))))) Regards Albert "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Albert,
What is the reason for using (90-1) instead of 89 !? Micky "albertmb" wrote: Hi Sherees, I am sure an expert can find a better formula, but until then you can try this: IF(A1<=79,"",IF(A1=80,"abc",IF(A1<=(90-1),"abc",IF(A1=90,"def",IF(A1<=(100-1),"def",IF(A1=100,"ghi",IF(A1<=(120-1),"ghi",""))))))) Regards Albert "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
I think that the 80 and 100 should be =, rather than ?
-- David Biddulph "????? (????) ?????" <micky-a*at*tapuz.co.il wrote in message ... Try: =IF(AND(A180,A1<89),"abc",IF(AND(A1=90,A1<99),"d ef",IF(AND(A1100,A1<119),"ghi",""))) Micky "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Couldn't
IF(A1<=79,"",IF(A1=80,"abc",IF(A1<=(90-1),"abc",IF(A1=90,"def",IF(A1<=(100-1),"def",IF(A1=100,"ghi",IF(A1<=(120-1),"ghi",""))))))) be simplified to IF(A1<=79,"",IF(A1<=89,"abc",IF(A1<=99,"def",IF(A1 <=119,"ghi","")))) ? The OP wasn't clear what was wanted if A1 was =89 and <90, or =99 and <100, and you've left the extra question about 79 and <80 [which latter question could have been avoided by changing your A1<=79 to A1<80]. It is possible that the OP wanted IF(A1<80,"",IF(A1<90,"abc",IF(A1<100,"def",IF(A1<1 20,"ghi","")))) though of course that wasn't what was asked for. -- David Biddulph albertmb wrote: Hi Sherees, I am sure an expert can find a better formula, but until then you can try this: IF(A1<=79,"",IF(A1=80,"abc",IF(A1<=(90-1),"abc",IF(A1=90,"def",IF(A1<=(100-1),"def",IF(A1=100,"ghi",IF(A1<=(120-1),"ghi",""))))))) Regards Albert "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Thanks a lot Micky!
Thank you too Albert but Mickys answer solved my question -- Life isa journey not a destination "מיכאל (מיקי) אבידן" wrote: Try: =IF(AND(A180,A1<89),"abc",IF(AND(A1=90,A1<99),"d ef",IF(AND(A1100,A1<119),"ghi",""))) Micky "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Hi,
Another approach possibly a bit shorter =LOOKUP(A1,{0,80,90,100,119},{"","abc","def","ghi" ,""}) but note your thresholds are very confusing. For example I.f A1 is equal to or greater than 80 but less than 89 If A1 is equal to or greater than 90 but less than 99 This means you want nothing in the cell if A1=89 bit I don't really believe you mean that so I have eliminated these 'gaps' -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''''s razor (Abbrev) "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Seems like I was wrong you do want gaps at 89,99 & 100 but I still prefer the
shorter approach =LOOKUP(A1,{0,80,89,90,100,119},{"","abc","","def" ,"ghi",""}) -- Mike When competing hypotheses are equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. Occam''''s razor (Abbrev) "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Formula for displaying a message
Good Question Mike, but it was my mistake, I used copy and paste and was
getting the same answer, at first I thought it was because I used the exact number but then I realised it was because I did not change the answer. I told you I am no expert No :) "מיכאל (מיקי) אבידן" wrote: Albert, What is the reason for using (90-1) instead of 89 !? Micky "albertmb" wrote: Hi Sherees, I am sure an expert can find a better formula, but until then you can try this: IF(A1<=79,"",IF(A1=80,"abc",IF(A1<=(90-1),"abc",IF(A1=90,"def",IF(A1<=(100-1),"def",IF(A1=100,"ghi",IF(A1<=(120-1),"ghi",""))))))) Regards Albert "Sherees" wrote: Hi If A1 is equal to or greater than 80 but less than 89,b1 =abc. If A1 is equal to or greater than 90 but less than 99, b1 =def. If A1 is equal to or greater than 100 but less than 119,b1 =ghi-- Please help Thanks Sherees Life isa journey not a destination |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula displaying don't know why | Excel Worksheet Functions | |||
| Stop displaying a message because of a formula | Excel Worksheet Functions | |||
| Same formula but ?value displaying | Excel Discussion (Misc queries) | |||
| MSN stock quotes - Error message "problem displaying attributes" | Excel Discussion (Misc queries) | |||
| Displaying an error message if entries exceed 100% | Excel Discussion (Misc queries) | |||
Linear Mode
