Thread: a+b<4 then 4,a+b<4 then sum a+b
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default a+b<4 then 4,a+b<4 then sum a+b
Hi,

=IF(A1+B1<4,4,A1+B1)

Regards,
Bondi

Reply With QuoteReply With Quote