formula IF > AND <

  • Thread starter Thread starter Jbcrtilla
  • Start date Start date
J

Jbcrtilla

I would like to tike a formula that IF for example a cell value is greater
than 5 but less than 10.01, the cell value is multiplied by 5 if true, or a
"-" is placed in cell if false. Can anyone help me please. thank you
 
Try this:-

=IF(AND(A1>5,A1<10.01),A1*5,"-")

If my comments have been helpful to you please click Yes.

Thanks!
 

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
Excel formulas 2
IF formula 5
IF function 3
Formula 12
If Formula involving date -not right 4
Condition formula 2
help with formula 1

Back
Top