View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default how do I write a formula: if (cell address) is less than X add Y

=a1+MAX(7.5,a2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CTrophyMan" wrote in message
...
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.