I don`t know how to add excel sheet here. Basically what I need though is to calculate a figure in column O (base value =100) and subtract figures from columns K,L,M,N . If the end result is still 100 then leave column O blank. Hope this explains it easy enough. Many thanks and apologies for not knowing how to attach sheet.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Calculate after subtracting figures from adjacent columns
- Thread starter shangela
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,548
- Office Version
- 365
- Platform
- Windows
Welcome to the MrExcel Message Board!
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Calculate after subtracting figures from adjacent columns
If you have posted the question at more places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!
Cross posted at: Calculate after subtracting figures from adjacent columns
If you have posted the question at more places, please provide links to those as well.
If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
Upvote
0
Similar threads
- Question
