formula IF AND <
 

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

formula IF AND <
 

Try this:-

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

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

Thanks!



"Jbcrtilla" wrote:

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

formula IF AND <
 

try using AND

=if(and(a25,a2<10.01),a2*5,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jbcrtilla" wrote in message
...
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