if then this statements

  • Thread starter Thread starter jsayssimon
  • Start date Start date
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
 

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

Excel Need Countifs Formula Help 0
If Formula for displaying a message 7
How to create a formula with multiple (IF) conditions 3
If statement for a range of cells 3
IF Function 2
Excel Formula Help 5
Conditional Formatting by percent range 2
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2

Back
Top