only calculate if >100

[KJensen]

I'm working on a little proggie in excel.

C16 = Some number

B19:B26 = some numbers

C19 =B19+B19/SUM($B$19:B$26)*C16
C20 =B20+B20/SUM($B$19:B$26)*C16
...
C26 =B26+B26/SUM($B$19:B$26)*C16

Lets say that if I only wanted to run the calculations on numbers >1000
?
Eg if B19 was 1200, then the calculations for C19 wouldn't be carried
out. How do I do that?

Thanks in advance

 

[Chip Pearson]

In C19, use

=IF(B19>1000,B19+B19/SUM($B$19:B$26)*C16,"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"KJensen" <[email protected]>
wrote in message
news:[email protected]...

 

[Bob Phillips]

=IF (B19>1000,B19+B19/SUMIF($B$19:B$26,">1000")*C16

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[SteveG]

Try this in C19 and copy down to C26.

=IF(B19>100,0,(B19+B19/SUM($B$19:B$26)*$C1$6))


HTH

Stev

 

[Guest]

You may use an IF condition before the calculation:
=IF(B19>1000,"Greater than 1000",B19+B19/SUM($B$19:B$26)*C16)

Hope this helps,
Miguel.

 

[KJensen]

Thanks for all the answers!

I got it working, I just had to change the "," to ";" - Don't know if
its because I have a Danish version of excel..

None the less, I got it working! - Thanks to you guys