#### 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--

Thanks
Sherees
Life isa journey not a destination
```
 0
Utf
1/16/2010 9:33:01 AM
excel.misc 78881 articles. 5 followers.

9 Replies
514 Views

Similar Articles

[PageSpeed] 1

```Try:
=IF(AND(A1>80,A1<89),"abc",IF(AND(A1>=90,A1<99),"def",IF(AND(A1>100,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--
>
> Thanks
> Sherees
> Life isa journey not a destination
```
 0
Utf
1/16/2010 9:46:01 AM
```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--
>
> Thanks
> Sherees
> Life isa journey not a destination
```
 0
Utf
1/16/2010 9:59:02 AM
```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--
> >
> > Thanks
> > Sherees
> > Life isa journey not a destination
```
 0
Utf
1/16/2010 10:06:01 AM
```I think that the 80 and 100 should be >=, rather than > ?
--
David Biddulph

"????? (????) ?????" <micky-a*at*tapuz.co.il> wrote in message
news:C292F59E-8E97-4C98-B3CE-562E9F194594@microsoft.com...
> Try:
> =IF(AND(A1>80,A1<89),"abc",IF(AND(A1>=90,A1<99),"def",IF(AND(A1>100,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--
>>
>> Thanks
>> Sherees
>> Life isa journey not a destination

```
 0
David
1/16/2010 10:28:11 AM
```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<120,"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--
>>
>> Thanks
>> Sherees
>> Life isa journey not a destination

```
 0
David
1/16/2010 10:32:56 AM
```Thanks a lot Micky!
Thank you too Albert but Mickys answer solved my question
--
Life isa journey not a destination

"מיכאל (מיקי) אבידן" wrote:

> Try:
> =IF(AND(A1>80,A1<89),"abc",IF(AND(A1>=90,A1<99),"def",IF(AND(A1>100,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--
> >
> > Thanks
> > Sherees
> > Life isa journey not a destination
```
 0
Utf
1/16/2010 10:50:01 AM
```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--
>
> Thanks
> Sherees
> Life isa journey not a destination
```
 0
Utf
1/16/2010 10:57:01 AM
```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--
>
> Thanks
> Sherees
> Life isa journey not a destination
```
 0
Utf
1/16/2010 11:10:01 AM
```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--
> > >
> > > Thanks
> > > Sherees
> > > Life isa journey not a destination
```
 0
Utf
1/16/2010 12:12:01 PM

Similar Artilces:

Isinteg Warning Message Question
I ran isinteg -pri -test alltests. I came up with 506 warnings. There are basically 4 types of warnings. They are below. Are these something I need to worry about? What should I do? thanks stewart sschwartz@nal.usda.gov ================================== Warning: MsgFolder 165 (Fid=0001-0000000D1864, Mid=0001- 0000000D559D, Inid=0001-000000F33436): PR_READ_RECEIPT_REQUESTED(0029000B) prop in Messages table and MsgFolder table do not match. Warning: MsgFolder 4 (Fid=0001-0000086DC911, Mid=0001- 00000436F972, Inid=0001-000004A583F1): Error JET_errRecordNotFound seeking to INID for this ...

Messages Cut off
A recipient receives forwarded mail messages that are cut off in random locations throughout the email. Outlook 2000 with latest SP. Any ideas? ...

Interface not registered message
when i try to send a e-mail message through outlook, i get the message interface not registered ? and then can't even save message. can anyone tell me why ? ...

Excel Opens Without Displaying Workbook
I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Displaying Workbook (http://support.microsoft.com/default.aspx?scid=kb;en-us;158996&Product=xlw97), but neither of the resolutions fixed the problem. Any suggestions?? Are you using Excel 97? -John Baughman Fort Collins, CO >-----Original Message----- >I am having issues with opening an Excel file. The file opens, but the workbook is not displayed. I tried the resolution in the article XL97: Excel Opens Without Di...

Joining text with a formula in cell #4
just to complete the thread... I found the answer. You have to change the format of the cell to custom 0.00"*" this is the only way it will show only 2 decimal places Thanks for the hel -- Mustard Hea ----------------------------------------------------------------------- Mustard Head's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1630 View this thread: http://www.excelforum.com/showthread.php?threadid=27700 ...

I am running Windows XP Pro & Outlook 2003 via POP3 & Symantec AV I had to reinstall everything on my pc and now find when I double click an email outlook hangs for roughly a minute and then it finally opens, I have tried a data compact, reinstalling outlook and creating a new pst then importing but it still happens Does anyone have any ideas? It's driving me mad Thanks Daz Try deleting and recreating the profile as one of your steps in troubleshooting: http://www.howto-outlook.com/Faq/newprofile.htm -- K. Orland Thoughts lead on to purposes; purposes go forth in action; ...

Display of UML State Transition Event
Dear Group, I am attempting to use the UML Statechart with a couple of states and a transition between them. I select properties, Events, Change Event type, say, and can see ChangeEvent1 in the property window but... ....when I Ok back to the drawing the ChangeEvent1 is not displayed by the transition. I can enter actions in a similar way and they are displayed. How cna I get the event visible too in the drawing? Surely this is the most important aspect of a transition i.e. what caused it, regards, Colin Smith ...

Extending formulas
Subject: Extending formulas Hi, For my application that uses Excel for calculations. I need to be able to extend the forula base of Excell with complex scientifc functions. Is there a way to add new functions to the Excel function base? Thanks Spx. MS has provided Visual Basic for Applications (VBA) to customize Excel with new functions, commands, forms, menus, etc. Tools|Macro|Visual Basic Editor From the VBA editor Insert Module Then write your functions in VBA. Details of writting functions in VBA is a very big topic, http://www.fontstuff.com/vba/vbatut01.htm may help y...

Outlook rule to move read message from Blackberry
I have Outlook configured with a Blackberry server and want to set up a rule to mange messages marked as read: For example. 1. I'm away from the office, Outlook is closed. 2. I read an email on my Blackberry, which marks the message "read" 3. When I return to the office and open Outlook I want to: a. Apply a rule to my inbox that states: If message is marked as read, move to folder "read messages" b. All unread messages will remain in the inbox. I'm a heavy user of rules but I can't find a way to identify "read" messages. Any thoughts? view360@gm...

Duplicate Messages
I have just upgraded from Office 2000 to Office XP. Ever since, i have been receiving duplicate email messages. Every time i do a send/receive, about 80% of my emails arrive twice (exactly the same ID, time, date etc.) I have got some rules running but these are necessary. Any ideas anyone. Thanks ...

Ctrl+D not working on outlook messages
Any idea why? alltimefav wrote: > Any idea why? And what are you expecting to happen? "alltimefav" wrote in message news:a95c52df-a387-4a8f-bf9d-269ff485451f@i29g2000prf.googlegroups.com... > Any idea why? So instead of hitting Ctrl+D to delete an item, what happens when the item is selected and you hit the Del key, or the "X" toolbar button, or right-click on the item and select Delete? Did you really expect a detailed response for such a vague question? You didn't even bother to say what "not working" means, like the item does not get delete...

Forwarded messages are not being sent
One of our users is trying to setup his account to forward all messages to his yahoo account. We setup a rule that says keep a copy in his inbox and forward a copy to his yahoo account. The yahoo copy never gets out and message tracking says it is submitted to the categorizer but never gets any farther. What do we need to do? By default rule-based forwards to external recipients are disabled. To change this, go to Exchange System Manager, Global Settings, Internet Message Formats.. There, you can either enable this for all domains (*), or be specific and create a separate policy f...

Need to add to current formula
I have this formula that will cause values to change based on the mont that is referenced in the formula (\$L\$1). Currently the formul is:=VLOOKUP(\$A\$1,\$AD\$7:\$AG\$44,IF(\$L\$1="January",2,IF(\$L\$1="February",2,IF(\$L\$1="March",2,IF(\$L\$1="April",2,IF(\$L\$1="MAY",4,IF(\$L\$1="June",3,IF(\$L\$1="July",3,0))))))),0) I need to add August, September, October, November, & December to thi formula but excel is not allowing me. Does anyone know how I can get around this? Oh by the way November thru April =2, May and October=4 and June thr...

Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains formula, but it didn't work. "If cell value is equal to 0 then font - white" This doesn't work, stays always. If i use this condition on a cell without formula it works just fine. Thank -- si ----------------------------------------------------------------------- sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262 View this thread: http://www.excelforum.com/showthread.php?threadid=26784 Hi are you sure your formula returns an exact zero?. Could you post the formul...

SUTA state message on Pay Code Integration
I'm having trouble importing pay codes that are based on another code, such as Sick and Vacation. These records get rejected with the error message "pay code 'V' requires a SUTA state". I have a SUTA state in the Emp Maint window and the HOURLY pay code already exists and contains a SUTA state. I tried mapping the SUTA State code in my file and even tried using a Constant value in Destination mapping but these codes will not import. I can go into the Pay Code Maintenance window and add these codes manually with no problem. What am I missing? ...

Problem displaying expected results with CString
I am writing a MFC program to import data from a single table database into a normalized database with numerous tables. The first component opens a recordset object to the database and performs some basic tests on the field value, and the plan is to write the records out to a spreadsheet that fail to meet any of the criteria defined for the field. Along with writing out the record, I want to populate a comments field describing what failed. I have tried to implement this with a CString variable; I initialize it to a blank string each time a new record is examined, and then as each field is che...

CRM Email Displays Size=2>
One of my users is experiencing an issue when they save an email that is tracked within CRM the email displays in CRM with "Size=2>" directly in front of certain lines of the email. So for example "Size=2>" will appear in front of someone's comments in the email or in front of their name. Does anyone know why "Size=2>" is displaying in front of the lines of an email? Thanks. Mike H. "Mike H." wrote: > One of my users is experiencing an issue when they save an email that is > tracked within CRM the email displays in CRM wit...

Formula Problem?
I am using Excel 2000 with Windows XP. I am having a problem. I am on Sheet 2 of my workbook. I have SSN on a sheet named Employees in the same workbook. I need to take the numbers on the Employees Sheet and transfer it to the sheet 2. I know how to do this. It just won't work. This is a copy of my formula. =SUM(Employees!C3) This should take the SSN that is in the C3 cell on the employees sheet and place it at the cell where the formula is typed. When I put this formula in the cell I am getting just a "0". Please help. =Employees!C3 -- Kind regards, Niek Otten...

formula auditing/macro
Can anyone give me the sytax to goto - special - precedents so I can create a macro so I can assign to a hotkey and dont have to go through 4 steps ? Thanks, Yosef With A1=1 and D2=2*A1, and D1 as active cell: I recorded a macro for these steps: Edit|GoTo->Special->Precedence And the macro contained just one line: Selection.DirectPrecedents.Select best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ynissel" <ynissel@discussions.microsoft.com> wrote in message news:DA544BDE-3717-4953-A5E3-06191BC28373@microsoft.com... > Can anyone...

SQL query / Formula for Reorder Point?
Is it possible to issue an SQL command(s) that would: 1. Set the Restock Level for all items to be equal to the current on-hand quantity for each item. 2. Set the Reorder point for all items to be equal to 1/3 of that items Restock Level. I'm currently doing this manually, or using a formula in excel when items are initially imported into the DB, but there are still several thousand that need to be retro-fitted like this... Thanx in advance! -=RFM=- UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted) UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0) - Evan Culver Ne...

copy values generated by conditional formula in one sheet to the other work sheet as values
Hi Everybody, I have data generated by conditional formulae in work sheet1 in columns A to J. If the condition is satisfied the cell will display a realnumber, if the condition doesn't satisfied the cell will display the text"FALSE". Now I wanted to copy the cells which have the real numbers in sheet1 to sheet2 as values(as we do with paste special and paste the values) Do we have any formula or other method to copy the cells in sheet1 to sheet2. can anybody helpme out in this issue. Thanks and Regards Ramana Select your range to copy edit|goto|special|c...

formula to have 0 to 6.5 only in ref to other cell val of 0<=6.5
...

Entourage (allegedly) cannot see message body sent by OWA
We have a external company receiving emails from us and claim they cannot see the message body when the email is sent from OWA. We are on 2003 SP2 btw. The external party claims that the following patch for OWA fixes the problem http://www.microsoft.com/downloads/details.aspx?familyid=5BC06E8A-08EB-4976-BC68-A03EBE3A2552&displaylang=en I am sceptical! Any thoughts Ignore!! I just saw another thread wit hthe details for this one. Thread is "OWA message text disappears" "Peter T" wrote: > We have a external company receiving emails from us and claim they cannot...

display in taskbar in excel 2000
Hello, Have a problem! I work with Office 2000 and excel does not open more than onw screen in the taskbar. Windows in Taskbar, I checked in Excel. Clustered display is turned off in the properties of the Taskbar. Can anyone help me with this problem prog, get it only if I 2x open excel. Regards Rob Hi Rob, I can't figure out what exactly what is happening in your excel but try this, Go to TOOLS (Menu Bar) then OPTIONS, in VIEW tab just CHECK the Windows in Taskbar. Hope this will help. ~jaeson ...

ACC: How to Display Line Numbers on Subform Records
I found this article on MS' website http://support.microsoft.com/kb/q120913/ but ran into problems when I pasted the code and tried to compile it. It gives a Compile Error: Method or data member not found when it reached the line below: RS.FindFirst "[" & KeyName & "] = " & KeyValue and it highlights "FindFirst". I have a sub-form (child) of a parent form's and I have a variable in the child that the user currently manually increments from 1,2,3 and so forth. Can this not be done w/o the user's intervention? Hi, ...