Help with an IF OR Function

[holykimura]

Hi I have two columns of data that contain values from 1 to 9 as well as the value "U". In a third column, i'm trying to determine whether a cell is equal to or above 7 in the either of the columns and if it is enter an "e" and if not " enter a "-". I am using the formula below however if the it is still it is not working in that when a "U" is present it still enters an "e" instead of a "-". I have attached an example and a fourth column of what it should be showing. If someone could help i would really appreciate it.

=IF(OR(A2>=7,B2>=7),"e",IF(OR(A2="U",B2="U"),"-","-"))

[windknife]

Try this,

=IF(OR(N(A2)>=7,N(B2)>=7),"e",IF(OR(A2="U",B2="U"),"-","-"))

[JohnTopley]

Try

=IF(OR(AND(N(A2),A2>=7),AND(N(B2),B2>=7)),"e","-")

[holykimura]

Hi they both work thanks! If you don't mind, so that i can understand it, what does the N do before the cell references?

[Glenn Kennedy]

Incidentally, can you check (and amend, if needed) your profile to show your current Excel product & (if O365) version?

[Pepe Le Mokko]

https://corporatefinanceinstitute.co...el/n-function/

[Glenn Kennedy]

If you DO have a recent version of O365, this can do the lot in one calculation:

=MAP(A2:A11,B2:B11,LAMBDA(x,y,IF(OR(AND(N(x),x>=7),AND(N(y),y>=7)),"e","-")))

N converts text to blank and leaves numbers as numbers.

[holykimura]

Great thanks! I don't have Office 365 only Office 2019

Thanks