| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if then this statements
Can anyone help me with this statement.
If A1 is equal to or less than 100 then divide by 5. If A1 is equal to or greater than 101 then subtract 100 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then this statements
This will do it:
=IF(A1<=100,A1/5,A1-100) "jsayssimon" wrote: Can anyone help me with this statement. If A1 is equal to or less than 100 then divide by 5. If A1 is equal to or greater than 101 then subtract 100 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if then this statements
=IF(A1<=100,A1/5,IF(A1=101,A1/100,"A1 is between 100 and 101 so answer is
undefined")) -- David Biddulph "jsayssimon" wrote in message ... Can anyone help me with this statement. If A1 is equal to or less than 100 then divide by 5. If A1 is equal to or greater than 101 then subtract 100 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statements | Excel Discussion (Misc queries) | |||
| If statements | Excel Discussion (Misc queries) | |||
| IF Statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| IF Statements | Excel Discussion (Misc queries) | |||
Linear Mode
