Percentages and comments

[alan green (wheelhouse)]

I'd like to be able to add another column in my spreadsheet that would do
the following: I'm working out efficiency ratings of our jobs and so it may
be above or below 100%. If it is below 100% I'd like the next cell to
calculate this and then put the text Below or something similar in that cell
alongside the percentage - it would save me having to do it!

Does anybody have any ideas?

 

[JE McGimpsey]

I'd like to be able to add another column in my spreadsheet that would do
the following: I'm working out efficiency ratings of our jobs and so it may
be above or below 100%. If it is below 100% I'd like the next cell to
calculate this and then put the text Below or something similar in that cell
alongside the percentage - it would save me having to do it!

Does anybody have any ideas?

One way:

Assume the efficiency ratings are in column C. Then

D2: =IF(C2<100%,"Below","")

Copy down as far as required.