Nawar Jameel
New Member
- Joined
- Aug 14, 2023
- Messages
- 4
- Office Version
- 2013
- Platform
- Windows
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
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