Jun 17 2020 04:32 AM
Hey everyone! My name is Melaia and i'm here to ask for some help.
I have an excel file that I need to use a formula, but the thing is, that I don't know how to make the formula.
My ideia is:
EXAMPLE:
If cell H5 is occupied with an e-mail, than fill cell N5 with that especific e-mail.
If cell H5 doesn't have any e-mail, go check cell H4, or H3, or H2.
If there isn't any information on any cell above, just let the final cell empty.
I know that I need to use the "IF" formula, but i don't know how to make the formula work.
What do I need to put in the first box?
And in the second one?
And in the final box?
I hope that someone could help me please. Thanks and nice day ! :)
Jun 17 2020 07:31 AM
SolutionJun 17 2020 07:55 AM
@Jan Karel Pieterse i don't get it.
it shows me this warning:
Jun 17 2020 08:10 AM
Jun 17 2020 08:55 AM
@Jan Karel Pieterse Nvm I already corrected the error with that code u gave me thanks a lot :)
Jun 17 2020 07:31 AM
Solution