Forumula IF issue

[Lensmeister]

Hi all,


I maybe missing a obvious resolution here but I am stumped.

In cell AO12 I havs a foumula tat calc a figure.

In cell AN12 I have the following forumula:

Please Login or Register  to view this content.

This now need to change but no matter what I have tried I can't fathom it out.

EDIT:
If the value of cell AO12 is > 355 but < 720 "A", if the Value is > 720 but <1085 then "B", if the value is >=1085 "C"

I still need to retain the =IF(B13="Issued",IF(G13="","", part as this is is the initial criteria for the calculation to start.

The A, B and C results then dictate a conditional formating elsewhere on the sheet.

I am probably being a bit of a dumbo ... where have I gone wrong?

[hemesh]

Hello lens what is value in A012 is less than 355

[hemesh]

=IF(AND(B13="issued",G13=""),"",IF(AND(AO12>=355,AO12<=720),"A",IF(AND(AO12>720,AO12<=1085),"B","C")))

Try this if value is always >=355 in AO12

[Lensmeister]

If the value if AO<355 "X".

I tried this:

Please Login or Register  to view this content.

[hemesh]

Try this in AN12 =IF(AND(B13="issued",G13=""),"",IF(AND(AO12>=355,AO12<720),"A",IF(AND(AO12>=720,AO12<1080),"B",IF(AO12>=1080,"C","X"))))

[Lensmeister]

Brilliant Thank you

[hemesh]

You are welcome lens