Please can someone clever help me with an excel formula

[RoomR0613]

I have limited skills on excel, and I've tried to be too clever and got in a mess with something.

Basically I need a formula that when the value of (e.g) cell B3 is 1 that it makes the value of (e.g cell B17) 0, but if there is no value entered in cell B3 (or I can enter a 0 if that helps) then I need it to instead pull through a value from (e.g) B34 from another sheet (let's call it the Gin sheet ) in the same workbook?

HELP

lmgtfy.com/?q=creating+an+excel+formula+with+multiple+if+conditions

Enter the following in the cell where you want to display the content of B17 or B34

=IF(B3=1,B17,B34)

=IF(B3=1,0,B34)

Does that work?

You might need to put the '1' and 0 in as text so surround with quote marks (which don't exist on my phone...)

=IF(B3=1,0,'Gin!B34')

Betsyboo87’s solution would work if you only care if B3 has a 1 in it and any other value or no value doesn’t matter. To reference another sheet, you would just change the B34 to Gin!B34 (but Excel will sort the reference for you when you get to typing that part of the formula and click on your other sheet and the cell you want there).

Cross-post with titchy!

YES THAT WORKS

(Well it did when I made it =IF(B3=1,B17,'Gin!B34) anyway )

That was a lot more simple than I had been making it in my head.

Thank you everyone!

Hmmm so it does work BUT

if I delete the 1 out of B3 then B17 reverts back to the value in GinB34 (great) but if I then put the 1 back into B3 , B17 doesn't go back to 0 it stays on GinB34 [cries]

I need B17 to change back and forwards between 0 or GinB34 depending on if there is a 1 in B3.

Is the 1 you're putting back in formatted as a number?

Is your formula in B17? If so, it can’t contain B17 as a ref... try t as Titchy wrote it.

Yes that works now. Thank you so much.

Great news