MIN MAX?????

[Utradeshow]

Hey Guy's How can you do this????

Say (A1*B1) and the result in C1 with a MINIMUM of 60 and a MAX of 120??

 

[iggydarsa]

do you mean something like

=IF(AND((A1*B1)>=60, (A1*B1)<=120), A1*B1, "")

 

[barry houdini]

Try

=MEDIAN(A1*B1,60,120)

 

[Utradeshow]

Try

=MEDIAN(A1*B1,60,120)

This works Great... Thank you..