Thread: if then formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004[_2_] joeu2004[_2_] is offline
external usenet poster
 
Posts: 829
Default if then formula

"rich123456" wrote:
=((J48-M48)*L48)+(K48*L48)
i need help adding this to this formula....
"if the total is less than 0 then use the number in L48"


=IF((J48-M48+K48)*L48<0,L48,(J48-M48+K48)*L48)

I took the liberty of making some algebraic simplifications as well.

If all of the values in J48, K48, L48 and M48 are non-negative, you can
simplify the IF() expression as follows:

=IF(J48+K48<M48,L48,(J48-M48+K48)*L48)