SOLVED

Formula problem!

%3CLINGO-SUB%20id%3D%22lingo-sub-1470377%22%20slang%3D%22en-US%22%3EFormula%20problem!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470377%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20everyone!%20My%20name%20is%20Melaia%20and%20i'm%20here%20to%20ask%20for%20some%20help.%3C%2FP%3E%3CP%3EI%20have%20an%20excel%20file%20that%20I%20need%20to%20use%20a%20formula%2C%20but%20the%20thing%20is%2C%20that%20I%20don't%20know%20how%20to%20make%20the%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20ideia%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3EEXAMPLE%3A%3C%2FP%3E%3CP%3EIf%20cell%20H5%20is%20occupied%20with%20an%20e-mail%2C%20than%20fill%20cell%20N5%20with%20that%20especific%20e-mail.%3C%2FP%3E%3CP%3EIf%20cell%20H5%20doesn't%20have%20any%20e-mail%2C%20go%20check%20cell%20H4%2C%20or%20H3%2C%20or%20H2.%3C%2FP%3E%3CP%3EIf%20there%20isn't%20any%20information%20on%20any%20cell%20above%2C%20just%20let%20the%20final%20cell%20empty.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20that%20I%20need%20to%20use%20the%20%22IF%22%20formula%2C%20but%20i%20don't%20know%20how%20to%20make%20the%20formula%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20I%20need%20to%20put%20in%20the%20first%20box%3F%3C%2FP%3E%3CP%3EAnd%20in%20the%20second%20one%3F%3C%2FP%3E%3CP%3EAnd%20in%20the%20final%20box%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20that%20someone%20could%20help%20me%20please.%20Thanks%20and%20nice%20day%20!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel.JPG%22%20style%3D%22width%3A%20566px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199212iB4E7BEDDE226593D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22excel.JPG%22%20alt%3D%22excel.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1470377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470825%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20problem!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470825%22%20slang%3D%22en-US%22%3E%3DSE(H5%26lt%3B%26gt%3B%22%22%3BH5%3BSE(H4%26lt%3B%26gt%3B''%3BH4%3BSE(H3%26lt%3B%26gt%3B%22%22%3BH3%3BSE(H2%26lt%3B%26gt%3B%22%22%3BH2%3B%22%22))))%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20not%20sure%20if%20you%20need%20the%20above%20or%20this%20syntax%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DSE(H5%26lt%3B%26gt%3B%22%22%2CH5%2CSE(H4%26lt%3B%26gt%3B''%2CH4%2CSE(H3%26lt%3B%26gt%3B%22%22%2CH3%2CSE(H2%26lt%3B%26gt%3B%22%22%2CH2%2C%22%22))))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470884%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20problem!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470884%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%20i%20don't%20get%20it.%3C%2FP%3E%3CP%3Eit%20shows%20me%20this%20warning%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22exceel.JPG%22%20style%3D%22width%3A%20609px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199236i46EC2A38064C72DB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22exceel.JPG%22%20alt%3D%22exceel.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EThere%20is%20a%20problem%20with%20this%20formula.%3CBR%20%2F%3E%3CBR%20%2F%3ENot%20trying%20to%20write%20a%20formula%3F%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20the%20first%20character%20is%20an%20equal%20sign%20(%3D)%20or%20a%20minus%20sign%20(-)%2C%20Excel%20considers%20it%20a%20formula%3A%3CBR%20%2F%3E%3CBR%20%2F%3Ewhen%20you%20type%3A%20%3D%201%20%2B%201%2C%20the%20cell%20displays%3A%202%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20avoid%20this%2C%20write%20an%20apostrophe%20()%20first%3A%3CBR%20%2F%3E%3CBR%20%2F%3Eif%20you%20write%3A%20%3D%201%20%2B%201%2C%20the%20cell%20displays%3A%20%3D%201%20%2B%201%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470918%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20problem!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470918%22%20slang%3D%22en-US%22%3EIf%20you%20type%20the%20equal%20sign%20(use%20any%20empty%20cell)%20and%20then%20hold%20down%20the%20control%20key%20and%20click%20on%20two%20separate%20cells%20(like%20A1%20and%20A3)%2C%20what%20does%20your%20formula%20look%20like%20exactly%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1471064%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20problem!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1471064%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%20Nvm%20I%20already%20corrected%20the%20error%20with%20that%20code%20u%20gave%20me%20thanks%20a%20lot%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 ! excel.JPG

4 Replies
Highlighted
Best Response confirmed by melaia (New Contributor)
Solution
=SE(H5<>"";H5;SE(H4<>'';H4;SE(H3<>"";H3;SE(H2<>"";H2;""))))

I'm not sure if you need the above or this syntax:

=SE(H5<>"",H5,SE(H4<>'',H4,SE(H3<>"",H3,SE(H2<>"",H2,""))))
Highlighted

@Jan Karel Pieterse  i don't get it.

it shows me this warning:

exceel.JPG

 
 
 
 
There is a problem with this formula.

Not trying to write a formula?

When the first character is an equal sign (=) or a minus sign (-), Excel considers it a formula:

when you type: = 1 + 1, the cell displays: 2

To avoid this, write an apostrophe () first:

if you write: = 1 + 1, the cell displays: = 1 + 1
Highlighted
If you type the equal sign (use any empty cell) and then hold down the control key and click on two separate cells (like A1 and A3), what does your formula look like exactly?
Highlighted

@Jan Karel Pieterse  Nvm I already corrected the error with that code u gave me thanks a lot