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

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

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

=IF(AND(cell1700,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)

"Truck driving woman" <Truck driving wrote
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

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

One extra comma:

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

example:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Bob Phillips" wrote in message ...
| =IF(AND(cell1700,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)
|
| "Truck driving woman" <Truck driving wrote
| 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
|
|

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

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(A11700,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


Replace @mailinator.com with @tiscali.co.uk


"Truck driving woman" <Truck driving wrote
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