S sitelbanat Board Regular Joined Oct 17, 2005 Messages 152 Dec 14, 2005 #1 Is there any command I can use to say up to in a formula, for example calculate up to 56
Richard Schollar MrExcel MVP Joined Apr 19, 2005 Messages 23,707 Dec 14, 2005 #2 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
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 MrExcel MVP Joined Jul 21, 2002 Messages 73,092 Dec 14, 2005 #3 You mean? =MIN(56,YourFormula)
daniels012 Well-known Member Joined Jan 13, 2005 Messages 5,219 Dec 14, 2005 #4 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
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 Dec 14, 2005 #5 Something like this: =MIN(56,A1) Will return any number in A1 up to 56. Hope that helps, Smitty