Microsoft Excel - need formula: if c3*d3 is less than 55, then fill with 55, if it is higher,fill exact
Asked By suzanne walker on 27-Mar-15 01:44 PM
I need a formula
if c3 * d3 is less than 55, then populate e3 with 55. if it is 55 or higher, then populate e3 with sum of c3*d3
Harry Boughen replied to suzanne walker on 27-Mar-15 02:37 PM
Hello Suzanne,
You might try:
=IF(C3*D3<55,55,C3*D3)
Regards
Harry