Display calculated '+' values?

[Abgirl]

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!!

[bebo021999]

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?

[AELLC]

See attached. I used Conditional Formatting - custom number set to ;;; hides the values if zero or less (negative)

Also - should F6 etc be =F5/(F3+F4) ?

[Abgirl]

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?

[bebo021999]

Assuming C column

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

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