Need 'If greater than x, add to cell" formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need help creating a formula. Essentially, if the number in column E is
greater than 3, than I need to add the balance (meaning any number in excess
of 3) to column L. Any help would be greatly appreciated.
 
Actually, the formula is more complicated than I originally wrote. It's
actually something like:
Cell L6 = K6-C6-(Any amount in excess of 3 in E6)



Does that make sense?
Kathy

Essentially, if the number in column E is
 
There is still an ambiguity in what you say.
Cell L6 = K6-C6-(Any amount in excess of 3 in E6)
Click to expand...

Do you mean the whole value greater than 3 (ie with 7 in E6 subtract 7) or
do you mean the difference between the value and 3 (ie 7-3 = 4)

Either:

=K6-C6-if(E6>3,E6,0)

or

=K6-C7-If(E6>3,E6-3,0)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
or is it

=K6-C7-If(E6>3,E6-3,E6);

or may I ask, what would you put in column L if it is less than 3 in column E?

thanx
 
This is the formula!! Thanks so much for your help:

=K6-C7-If(E6>3,E6-3,0)


Best Regards!
 
Back
Top