is there anyway i can use the formula =ROUNDUP(SUM(C13*60*$D$19*$I$22),0.5)
in a column until the column total reaches 600 then have the formula change to =ROUNDUP(SUM(C13*60*$D$20*$I$22),0.5). changing one of the cells in the formula. i would also like the column to turn a different colour at this point if possible.
=IF(ROUNDUP(SUM(C13*60*$D$19*$I$22),0.5)<=600,ROUNDUP(SUM(C13*60*$D$19*$I$22),0.5),ROUNDUP(SUM(C13*60*$D$20*$I$22),0.5))
For highlighting the cell with different colors, please use conditional formatting.
Hi,
It's not clear exactly what you mean. If you mean when the column C total passes 600 starting at C13 then in C13 copied down
Formula:
Please Login or Register to view this content.
If that's not what you mean then upload the workbook and manually add a set of results with notes explaining how you have calculated the results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
i still need help. im just putting notes on the spreadsheet.
thanks for the help
the problem im having is on the board data sheet
thanks again
Hi,
It's still not completely clear since all your column E formuale are the same. Y9ou've neither manually added the results as requested or changed a formula.
I'm guessing but are you expecting E14 to change since this is the formula that takes the cumulative past E19.
And I'm not clear about the second question you pose. But again we need to see an example of the results you expect to see.
sorry it was poor.
maybe this is more what you asked for.
i had changed the formula, i just clicked through undo when it didnt have the result i had expected.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks