| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | | |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) | |||
Linear Mode
