IF Formulas

[Forrest87]

Hi Folks,

I' am struggling with the below formulas. Please can anyone help?
I have column U and column V with values. If column U is the same as V, I need it to return text Ok. If both cells are 0, I also need my formula cell to return the text Ok. If cell U is greater than U, I need my formula cell to return the text review.

So far I have tried the below formulas but none of them are working for all of my results.

=IF(AND(U6>V6,U6=V6),"Review","OK")
This formula works for the amounts that match and that are 0 but not if U cell is higher than the V cell

=IF(AND(U6=V6,"Ok"',) & IF(AND(U6>=V6'"Review","")
This one keeps returning both texts in the same cell

Any help would be appreciated, thanks!

 

[arthurbr]

Try =IF(V6=U6,"OK",IF(U6>V6,"review,""))

 

[Forrest87]

Hi arthurbr,

Thanks for the reply. The formula doesn't seem to be working

 

[Forrest87]

Hi all, any suggestions? Tried doing it as an IF and Or function but I still return the same issues mentioned above

 

[arthurbr]

What does not work?
The formula says : if both cells are equal, "OK",if U6>V6, "review", and if V6>U6, leave blank. Is that not what you asked for ?

What kind of values are you comparing? Numbers? Are they real numbers or text looking like numbers?