only calculate if >100

K

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
 
B

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

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
 
M

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.
 
K

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
 
Top