Notifications
Clear all
Topic starter
Hi, i need help with a formula as i cant seem to get it working with the if function. I have 7 collums, each represent a reporting line e.g. collumn A is the CEO and collumn B the Director, C department manager etc. but as it gets further down some will be blank at they dont have lower levvels of supervision (example below) I need a formula that will say if G1 is blank but F1 is not blank return CEO minus 5 but if it is blank and E1 is not blank return CEO minus 4 etc (example of result wanted below).
| 5830 | 5497 | 5682 | 5456 | 6010 | CEO minus 5 | ||
| 6407 | 6410 | 3333 | 5488 | CEO minus 4 | |||
| 6407 | 6410 | 5399 | 5844 | CEO minus 4 | |||
| 6407 | 6410 | 5296 | 5730 | CEO minus 4 | |||
| 5830 | 5497 | 5682 | 6023 | 6295 | 5940 | CEO minus 6 |
Thanks in advance
Posted : 12/02/2021 1:22 pm
Hi Louise,
Here is a solution in column I (in blue).
BR,
Lionel
Posted : 12/02/2021 1:56 pm
Thank you so much that’s amazing & such a simple solution. I was definitely over complicating it!
Posted : 13/02/2021 9:53 am
Try
="CEO minus " & COUNTA(A1:G1)
Posted : 13/02/2021 10:31 am
