PDA

View Full Version : Help with a Formula



ghostbroker2
10-31-2017, 12:01 PM
I need a formula in cell C2 that says that if cell D3 is greater than or equal to 1.75, it will display the number.
If it is less than 1.75 it will display "1.75".
Any help is appreciated.

Sandler
10-31-2017, 12:54 PM
=IF(D3>=1.75,D3,1.75)

ghostbroker2
10-31-2017, 01:43 PM
Thank you !

p45cal
10-31-2017, 03:30 PM
Or
=Max(D3,1.75)