FORMULA

[sitelbanat]

Is there any command I can use to say up to in a formula, for example calculate up to 56

 

[Richard Schollar]

Hi

You are going to have to provide some contextual information here as to what exactly you are trying to achieve. 56 what?

Best regards

Richard

 

[Andrew Poulsom]

You mean?

=MIN(56,YourFormula)

 

[daniels012]

Need more info.
Give us an example of what you are trying to accomplish. More info in your subject will get you more hits aslo!

Michael

 

[Smitty]

Something like this:

=MIN(56,A1)

Will return any number in A1 up to 56.

Hope that helps,

Smitty