If statement Issue

**Dinho05** · 12-20-2012, 02:42 PM

Hi all,
Im new to excel and trying to write an if statement that returns a value from 1 of 2 cells based on the condition.

Example of what I want to do is below: In a workbook of 3 sheets

If Cell B3 = 0 in sheet2 return Value in cell B3 of sheet 3 into cell B3 of sheet 1

If not return value in cell B3 of sheet2 into cell B3 of sheet 1.

Not sure that the if statement is the way to go hear but ill appreciate some help.

**FDibbins** · 12-20-2012, 02:47 PM

try this...

=if('sheet2'!B3=0,'sheet3'!B3,'sheet2'!B3)

**Dinho05** · 12-20-2012, 03:39 PM

FDibbins, thanks for your response and that is the statement I tried first and it is not working. Actually I just created a different spreadsheet and the expression above works just fine but in the report I'm working on it doesnt populate the values from sheet3. The cell in sheet 1 is blank when it is supposed to be populated by the value from sheet 3.

Would you happen to know what that is happening?

**FDibbins** · 12-20-2012, 03:41 PM

are you using sheet 3....sheet3 or a different name altogether? (altho excel should tell you off if it cant find the sheet name)

do you actually have anything in sheet2 B3?

maybe upload a sample workbook and i will take a look at it