Thread: Equations
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Sandy is offline
external usenet poster
 
Posts: 270
Default Equations

Type =IF(B4*C4/144<3,3,B4*C4/144) into D4 and then copy down

hth Sandy

"
wrote in message ...
the equation is =SUM(B4*C4)/144 the answer is 2.5 if I want the minimum
answer to be 3 how would I do it or is it possible