FORMULA

sitelbanat

Board Regular
Joined
Oct 17, 2005
Messages
152
Is there any command I can use to say up to in a formula, for example calculate up to 56
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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
 

daniels012

Well-known Member
Joined
Jan 13, 2005
Messages
5,219
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

Legend
Joined
May 15, 2003
Messages
29,536
Something like this:

=MIN(56,A1)

Will return any number in A1 up to 56.

Hope that helps,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,118,035
Messages
5,569,784
Members
412,292
Latest member
The Bear named Joe
Top