Figuring percentages in Excel
Solved/Closed
mt
-
Jan 26, 2010 at 12:02 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2010 at 09:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2010 at 09:40 PM
Related:
- Figuring percentages in Excel
- Percentage formula in excel marksheet - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to take screenshot in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 29, 2010 at 09:40 PM
Jan 29, 2010 at 09:40 PM
presuming your sheet look like this
Col A Col B COL C
WEEK LOSS
week 1 -10
week 2 -14
week 3 0
week 4 1
you can use in Col C formula as
=IF(ISNUMBER(C1),C1+B2,B2)
Col A Col B COL C
WEEK LOSS Week Cumm
week 1 -10 -10
week 2 -14 -24
week 3 0 -24
week 4 1 -23
Col A Col B COL C
WEEK LOSS
week 1 -10
week 2 -14
week 3 0
week 4 1
you can use in Col C formula as
=IF(ISNUMBER(C1),C1+B2,B2)
Col A Col B COL C
WEEK LOSS Week Cumm
week 1 -10 -10
week 2 -14 -24
week 3 0 -24
week 4 1 -23