Thread: if then formula
View Single Post
  #1   Report Post  
rich123456 rich123456 is offline
Junior Member
 
Posts: 2
Default if then formula

i have a formula in a cell that totals the amounts in that row.

here is the formula

=((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"

any help here would be greatly appreciated.