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

[SteveG]

Try this in C19 and copy down to C26.

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


HTH

Steve

[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]...
>
> 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
>

[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)

"KJensen" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Miguel Zapico]

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" 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
>
>

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