Thread: Minimum Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Minimum Formula

=if(Sum((A3*2+B3*2)*$R$2)<.38,.38,Sum((A3*2+B3*2)* $R$2))



"George" wrote:

Excel 2007
Hello, I am using the following formula;
=Sum((A3*2+B3*2)*$R$2)
This formula is in cell R3, I would like to use the above formula, but I do
not want the value in cell R3 to drop below .38