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.
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.
=a1+MAX(7.5,a2)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"CTrophyMan" <[email protected]> wrote in message
news:[email protected]...
> 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.
=A1+(MAX(7.5,B1))
--
Kind regards,
Niek Otten
"CTrophyMan" <[email protected]> wrote in message
news:[email protected]...
>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 CTrophyManOriginally Posted by 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
HI
Cell one is A1
Cell Two is B1
Formula in Cell three
=if(B1>=7.5, SUM(A1:B1), A1+7.5)
--
Cillian
"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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks