IF statement returning FALSE

[ExcelRoy]

Hi all,

I have the following formula

=IF(ER3="","",IF(FH3<>"",FH3))

This returns FALSE when I need it to shoe ER3 or FH3

This formula is in FG3

Thanks for any help

 

[Joe4]

It is not written correctly. Nowhere are you telling it to return ER3.
Can you just explain in plain English exactly how you want this to work?

 

[Marcelo Branco]

This?

=IF(ER3="",IF(FH3<>"",FH3,""),ER3)

M.

 

[ExcelRoy]

Hi,

I know this should be simple sorry but …

IF ER3 ="" then ""
IF ER3 <>"" then "Backorder" except if FH3 <>"" the FH3

Thanks

 

[Marcelo Branco]

Try

=IF(ER3="","",IF(FH3<>"",FH3,"Backorder"))

M.