Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
I'm using the following formula: =IFS(J27>J26,"PLUS",J27<J26,"MINUS",J27=J26,"LEVEL") and what I would like to do is add the contents of cell K28 to display with "PLUS" or "MINUS"
for example to show MINUS the value of K28 but without the minus symbol (or plus symbol in the case of PLUS. If LEVEL there is nothing additional to display other.
i.e. MINUS 1, PLUS 2 etc.
Can anyone point me in the right direction, please?
Mel
for example to show MINUS the value of K28 but without the minus symbol (or plus symbol in the case of PLUS. If LEVEL there is nothing additional to display other.
i.e. MINUS 1, PLUS 2 etc.
Can anyone point me in the right direction, please?
Mel