Actually, if F4 ="N" the result should be the greater of (rate*O4) or 150
How would I add the above to the formula below??????

"Peo Sjoblom" wrote:

What do you want the formula to return if F4 is not "Y"?

=IF(F4="Y",MAX(MIN(RATE*O4,275),150),"No") <<<<<<<<<<<<<


--
Regards,

Peo Sjoblom


"marwildfw" wrote in message
...
Please tell me how to write this formula.

=IF(E4="H",0,IF(F4="Y",275,(RATE*O4)))

The above statement works fine but it gives me the worng answer. The
maximum
amount cannot exceed 275 and the minimum cannot be less than 150. The
portion of the formula beginning at F4 really needs to say:

IF F4=Y,(RATE*O4),BUT NOT LESS THAN 150 OR MORE THAN 275

In english, the cell occupied by this formula should equal the sum of
(RATE*O4) but the result cannot be less than 150 or more than 275.

Can anyone helP?

=IF(F4="Y",MAX(MIN(RATE*O4,275),150),if(f4="n",max (Rate*o4,150),"Neither Y
nor N"))

"marwildfw" wrote:

Actually, if F4 ="N" the result should be the greater of (rate*O4) or 150
How would I add the above to the formula below??????

"Peo Sjoblom" wrote:

What do you want the formula to return if F4 is not "Y"?

=IF(F4="Y",MAX(MIN(RATE*O4,275),150),"No") <<<<<<<<<<<<<


--
Regards,

Peo Sjoblom


"marwildfw" wrote in message
...
Please tell me how to write this formula.

=IF(E4="H",0,IF(F4="Y",275,(RATE*O4)))

The above statement works fine but it gives me the worng answer. The
maximum
amount cannot exceed 275 and the minimum cannot be less than 150. The
portion of the formula beginning at F4 really needs to say:

IF F4=Y,(RATE*O4),BUT NOT LESS THAN 150 OR MORE THAN 275

In english, the cell occupied by this formula should equal the sum of
(RATE*O4) but the result cannot be less than 150 or more than 275.

Can anyone helP?