only calculate if 100
 

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


--
KJensen
------------------------------------------------------------------------
KJensen's Profile: http://www.excelforum.com/member.php...o&userid=34677
View this thread: http://www.excelforum.com/showthread...hreadid=544440

only calculate if 100
 

In C19, use

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


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



"KJensen"
wrote in message
...

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


--
KJensen
------------------------------------------------------------------------
KJensen's Profile:
http://www.excelforum.com/member.php...o&userid=34677
View this thread:
http://www.excelforum.com/showthread...hreadid=544440

only calculate if 100
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"KJensen" wrote in
message ...

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


--
KJensen
------------------------------------------------------------------------
KJensen's Profile:
http://www.excelforum.com/member.php...o&userid=34677
View this thread: http://www.excelforum.com/showthread...hreadid=544440

only calculate if 100
 

Try this in C19 and copy down to C26.

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


HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=544440

only calculate if 100
 

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

Hope this helps,
Miguel.

"KJensen" wrote:


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


--
KJensen
------------------------------------------------------------------------
KJensen's Profile: http://www.excelforum.com/member.php...o&userid=34677
View this thread: http://www.excelforum.com/showthread...hreadid=544440

only calculate if 100
 

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 :D


--
KJensen
------------------------------------------------------------------------
KJensen's Profile: http://www.excelforum.com/member.php...o&userid=34677
View this thread: http://www.excelforum.com/showthread...hreadid=544440