How can I say "If cell value is > 1700 but < 2599, then * .25 else

  • Thread starter Truck driving woman
  • Start date
T

Truck driving woman

How can I say "If cell value is > 1700 but < 2599, then * .25 else 0"? I'm
actually working with the Microsoft Works spreadsheet, but I think the
formulas are pretty much the same. It's been so long since I messed with this
stuff.... Thanks much
 
B

Bob Phillips

=IF(AND(cell>1700,cell<2599)cell*.25,0)

in Excel, no idea about Works

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
N

Niek Otten

One extra comma:

=IF(AND(cell>1700,cell<2599),cell*0.25,0)

example:

=IF(AND(A1>1700,A1<2599),A1*0.25,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| =IF(AND(cell>1700,cell<2599)cell*.25,0)
|
| in Excel, no idea about Works
|
| --
| HTH
|
| Bob
|
| (there's no email, no snail mail, but somewhere should be gmail in my addy)
|
| in message | > How can I say "If cell value is > 1700 but < 2599, then * .25 else 0"? I'm
| > actually working with the Microsoft Works spreadsheet, but I think the
| > formulas are pretty much the same. It's been so long since I messed with
| > this
| > stuff.... Thanks much
|
|
 
S

Sandy Mann

It is a long time since I used Works so I cannot remember is it has the
AND() function. If it does not then try:

=IF(A1>1700,IF(A1<2599,A1*0.25,""),"")

There is a dedicated Workd Newsgroup at:

microsoft.public.works.win

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top