IF Formual

[RichPee]

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

[zbor]

Use:

Please Login or Register  to view this content.

[RichPee]

Hi zbor, that worked great thank you.