| 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 |
| 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) | |||
Threaded Mode
