Hi,

I am using this formula =IF((D27/$H$12*$L$17)<3, "3", D38) to basically - if the first formula (D27/$H$12*$L$17) results in less than 3 then it just shows 3 however, if it is greater than three then I want the answer from (D27/$H$12*$L$17) to show.

Can anyone help?

Thanks,

Richard