Need Help w/Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Need Help w/Formula

FAQ

Thread Tools

Display Modes

09-28-2013, 05:39 AM

Pecoflyer

Windows 7 64bit Need Help w/Formula

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Hi and welcome

Say your limit is 75

In your result cell (say A11)

Code:

= MIN(75,sum( a1:a10))

In the next cell ( say B11)

Code:

=MAX(0,sum(a1:a10)-75)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Help	OTPM	Excel	2	05-22-2013 06:28 AM
IF formula	MARK SMITH	Excel	2	04-04-2013 01:58 PM
formula help	rich_cirillo	Excel	3	09-26-2012 11:41 PM
formula help	excelledsoftware	Excel	8	03-25-2012 08:49 AM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:13 AM.