IF then

[Nawar Jameel]

Hello Everyone

Hoping you are all well

Can you help me please

I need a formula in column-E to copy the value in column-R but if column-R is empty then copy value from column-M and if column-M is empty then copy value from column-H and finally if column-H is also empty then the formula in column-E will only return null.

I tried the below two formulas but unfortunately both of them did not workout.

=IF(R65="",M65,IF(M65="",H65,IF(H65="","")))

=IF(NOT(ISBLANK(H63)),H63,IF(NOT(ISBLANK(M63)),M63,IF(NOT(ISBLANK(R63)),R63,"")))

Example of sheet:

Thank you all

 

[Tetra201]

Maybe

=IF(R65<>"",R65,IF(M65<>"",M65,IF(H65<>"",H65,"")))

 

[Skyybot]

In cell E65

=IF(ISBLANK(R65),IF(ISBLANK(M65),IF(ISBLANK(H65),"Null",H65),M65),R65)

 

[Phuoc]

Or try:

=IF(R65<>"",R65,IF(M65<>"",M65,H65&""))

 

[Nawar Jameel]

Maybe

=IF(R65<>"",R65,IF(M65<>"",M65,IF(H65<>"",H65,"")))

Many thx it works good

u r legend

 

[Nawar Jameel]

In cell E65

=IF(ISBLANK(R65),IF(ISBLANK(M65),IF(ISBLANK(H65),"Null",H65),M65),R65)

Much appreciated mate

u r Diamond

 

[Nawar Jameel]

Or try:

=IF(R65<>"",R65,IF(M65<>"",M65,H65&""))

Thank you very much mate