formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to subtract one cell value from another with a return of not greater than a constant number. Example: b2(18.25)-a2(7.00)= 8.00, even though the actual result is greater than 8.00. What formula can I use to calculate this?
 
this should work

if(b2-a2>8,8,b2-a2

if the total is more than 8 it will return 8 if not it will give the actual difference

----- Odie2 wrote: ----

I am trying to subtract one cell value from another with a return of not greater than a constant number. Example: b2(18.25)-a2(7.00)= 8.00, even though the actual result is greater than 8.00. What formula can I use to calculate this?
 
=MIN(B2-A2,D1)

Then type 8 or whatever you want to change it to in D1

Vaya con Dios,
Chuck, CABGx3



Odie2 said:
I am trying to subtract one cell value from another with a return of not
Click to expand...
greater than a constant number. Example: b2(18.25)-a2(7.00)= 8.00, even
though the actual result is greater than 8.00. What formula can I use to
calculate this?
 
I used a suggested formula MIN(b2-a2,8). This worked for what I wanted but I will keep your suggestion for further reference. Thanks for the help.
 
Back
Top