IF statement returning FALSE

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,406
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
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,486
Office Version
  1. 365
Platform
  1. Windows
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?
 

ExcelRoy

Well-known Member
Joined
Oct 2, 2006
Messages
2,406
Hi,

I know this should be simple sorry but …

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

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,109,315
Messages
5,527,961
Members
409,795
Latest member
Manu9211

This Week's Hot Topics

Top