formulas

[Odie2]

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?

 

[Frank Kabel]

Hi
try
=MIN(B2-A2,8)

Frank

 

[JE McGimpsey]

One way:

= MIN(8, B2-A2)

 

[Rmills]

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?

 

[CLR]

=MIN(B2-A2,D1)

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

Vaya con Dios,
Chuck, CABGx3

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?

 

[Odie2]

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.

 

[Odie2]

This worked just great. Thank you very much.