if then this statements

J

jsayssimon

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
 
D

David Biddulph

=IF(A1<=100,A1/5,IF(A1>=101,A1/100,"A1 is between 100 and 101 so answer is
undefined"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word 2013 field code Nested IF statement 1
Greater Less or Equal 3
Page numbering with Merged Document and IF statements 1
If Formula for displaying a message 9
Mail Merge Help 1
How to create a formula with multiple (IF) conditions 4
Countif, IF condition is met 2
If statement for a range of cells 3

Top