ExcelBanter - if then this statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if then this statements (https://www.excelbanter.com/excel-discussion-misc-queries/258465-if-then-statements.html)

jsayssimon

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

darkside7out

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

David Biddulph[_2_]

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

All times are GMT +1. The time now is 02:10 PM.