Excel IF formula - Priority setting
Closed
Kobusdebeer
Posts
1
Registration date
Wednesday November 7, 2018
Status
Member
Last seen
November 7, 2018
-
Nov 7, 2018 at 04:15 AM
Blocked Profile - Nov 7, 2018 at 03:05 PM
Blocked Profile - Nov 7, 2018 at 03:05 PM
Good day
I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option indication a symbol or not. Each symbol if selected indicates progress on a project in a separate cell (A), i.e. Reported, Initiated, In Progress, etc. Unfortunately I have to remove the symbol (i.e, Cell B) each time the status of the project changes and then select the symbol in another cell (i.e, C) to display the current status. I need to have the project status displayed in the cell A by selecting the updated symbol in cells B-F without removing the previous symbol, in other words the next symbol selection should take preference over the previous one.
Please advise
=IF(I9='Security Safety Meeting - 2019.xlsm'!MARK,Master!$J$3,IF(J9=MARK,Master!$J$4,IF(K9=MARK,Master!$J$5,IF(L9='Security Safety Meeting - 2019.xlsm'!MARK,Master!$J$6,IF(M9=MARK,Master!$J$7)))))
I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option indication a symbol or not. Each symbol if selected indicates progress on a project in a separate cell (A), i.e. Reported, Initiated, In Progress, etc. Unfortunately I have to remove the symbol (i.e, Cell B) each time the status of the project changes and then select the symbol in another cell (i.e, C) to display the current status. I need to have the project status displayed in the cell A by selecting the updated symbol in cells B-F without removing the previous symbol, in other words the next symbol selection should take preference over the previous one.
Please advise
=IF(I9='Security Safety Meeting - 2019.xlsm'!MARK,Master!$J$3,IF(J9=MARK,Master!$J$4,IF(K9=MARK,Master!$J$5,IF(L9='Security Safety Meeting - 2019.xlsm'!MARK,Master!$J$6,IF(M9=MARK,Master!$J$7)))))
Related:
- Excel IF formula - Priority setting
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
1 response
Perhaps you need to build another colum for a lookup, from most important to least. Then the lookup, will match on the first one, which will be the one up the chain higher than the previous. I think you are running into a code firing problem. Just have it do what it is currently doing on a worksheet change method. Try that first.
