Thread: Display calculated '+' values?

Hi - I've been trying & my brain has now stopped!!

I have a table showing:
Actual amount of skilled resource
Required amount of skilled resource
Skills Gap

I need to display the cells where there are enough resources (or more than enough!) as a '+' figure & percentage - but I cannot get it to work and I know I am going to kick myself when someone gets it down flat in about 30 seconds!!

Attached spready for example.

Thanks in advance!!

It is not clear for me! How to value resource as "enough","more than enough" or "less"? could you pls put the outcome into where you need?

Hi bebo
Sorry - In essence I need this to show the % complete we are in an area up to a value of 100%.
E.g.
Skills needed = 3
Skills Available = 2
Gap = 1
% complete = 66%

Skills needed = 3
Skills Available = 3
Gap = 0
% complete = 100%

Skills needed = 3
Skills Available = 5
Gap = + 2
% complete = 100%

Hope this makes more sense?

Assuming C column

Skill Gap: C5 =IF(C4>C3,"+","")&ABS(SUM(C3-C4))

Percentage: C6 =IF(C3>C4,C4/C3,1)