IF Function with multiple varibles and comparatives

[AKRefugee]

EXCEL 2007



I am working on a workbook with multiple with multiple sheets. I need to have it do the following


Formula needed for sheet 3 cell A15


Formula requirements


Check Sheet 1 A15 for data if there is data than use sheet 1 A15 if blank than check sheet 2 D16
for data if there is data in sheet 2 D16 than use sheet 4 C16 data but before doing that check and
see it matches sheet 1 A16 if it matches than leave it blank if it does not than use data from
sheet 4 C16 if there is no data in both Sheet 1 A15 and Sheet 2 D16 then Sheet3 A15 should be blank


Cell Formatting


Sheet 1 A15 text
Sheet 2 D16 number
Sheet 4 C16 text
Sheet 3 A15 general


I am using this formula
=IF(ISTEXT('Sheet 1!A15), 'Sheet 1!A15,IF(ISNUMBER('Sheet 2'!D16),IF('Sheet 3'!C16='Sheet 3'!A14,"",’sheet4’!C16),'Sheet 1'!A15))

When I use this formula and Sheet 1 A15 is blank and Sheet 2 D16 is blank
I get a response of 0. What I need under those conditions is a response of blank.
Everything else in the formula works the way it should.

Thanks for any assistance you can give me.

 

[anglais428]

you need "" as your last false statement

 

[AKRefugee]

Thanks anglais428. That was exactly what it needed. Sometimes you work on something so much that you miss the obvious. Appreciate that.