CTrophyMan Wrote:
I am using Excel 2003 and I want to write a formula to add 2 cells with
a
condition that is the second cell value is less than a preset amount,
i.e.
$7.50 then add the preset amount instead of the value in the second
cell.
Hi CTrophyMan
Assuming your values to be in cells A1 & B1 in C1 use this formula
=IF(B1<7.5,A1+7.5,A1+B1)
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile:
http://www.excelforum.com/member.php...o&userid=24783
View this thread:
http://www.excelforum.com/showthread...hreadid=489888