Multiply value as X or a running total lesser than X

[LifeDancer]

Hi,
I'm looking to create a formula that calculates based on either the entire running total, or a specific number that is less than the running total.

Example:
Mileage is input daily in column E, and a running total is calculated in column F.
If the final running total in cell E34 is less that 833, then E34*0.45 is the required result.
If the running total in E34 is greater than 833, then the calculation needs to be 833*0.45.

Is there a way to ask for the value to be either 833 or E34, whichever is lesser?

Thanks for any suggestions.

 

[dreid1011]

Without seeing a sample of your data, it sounds like you could use the MIN() function. Something like this:

=MIN(E34,833)*.45

 

[LifeDancer]

Hi
@dreid1011

=MIN(E34,833)*.45

Perfect! Thank you.

 

[dreid1011]

You're welcome, and happy to help.