| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to calculate days between dates or back date | Excel Discussion (Misc queries) | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| how do i link 3 worhseets to calculate into one | Excel Worksheet Functions | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
Linear Mode
