Formula returning value?

[jamesa2487]

Hi

I have a formula in column H that returns a word based on a value, its all working fine but as you will see in the attached it is returning "red" even if the cells to the left are empty

Any ideas?

[LukeGilfoyle]

Use this:

=IF(G2="","",IF(G2>1,"Red",IF(F2>0.9,"Green",IF(F2>0.79,"Amber","Red"))))

[davesexcel]

That is what the formula indicates. If it does not meet the criteria, it is red.

Please Login or Register  to view this content.

Change the last "Red" to something else.
Also there may be something in G2, I pressed delete in G2 and the formula worked properly.

[jamesa2487]

Hi

In the main it works only problem now is if it is red with

[LukeGilfoyle]

This:

=IF(AND(G2="",F2=""),IF(G2>1,"Red",IF(F2>0.9,"Green",IF(F2>0.79,"Amber","Red"))),"Red")

[jamesa2487]

That is now returning "red" when there is no result, i will try to explain better

Coloum F & G - Have a vlookup formula in

What i need H to do

[jamesa2487]

its fine now, the formula you gave seems to work with the vlookup, its just if i type a manual score over the top it doesnt

[LukeGilfoyle]

Try this:

=IF(F2="","",IF(G2>1,"Red",IF(F2>0.9,"Green",IF(F2>0.79,"Amber","Red"))))

Make sure you press F9 to re-calculate (or even better, turn back on "Automatic Calculations"

Thanks