If cell B1 is 0 show number in cell A1

[pano]

Hope u can help,
Need a formula to add on to B1. I have this at the moment linking to
another sheet in B1

A1 B1
1234 ='1'!$B$2

I need to add into B1 that if it is 0 show number in A1?
Thanks
Steve

 

[T. Valko]

Maybe this:

=IF('1'!$B$2=0,A1,'1'!$B$2)

Biff

 

[Gord Dibben]

The only way to show a number in A1 is to have a formula in A1 that returns a
number based on what is in '1'!$B$2

Formulas can "pull" data from other cells, not "push" data.

=IF('1'!$B$2=0,1234,"not zero") entered in A1

Unless you want to use VBA, of course.


Gord Dibben MS Excel MVP

 

[pano]

Maybe this:

=IF('1'!$B$2=0,A1,'1'!$B$2)

Biff



Biff it picks up value in other sheet ='1'!$B$2 but if the cell B1 is 0 it wont pick up cell A1 1234 and place it in cell B1

hmmmmmmm any other ideas???

 

[pano]

Maybe this:

=IF('1'!$B$2=0,A1,'1'!$B$2)

Biff








- Show quoted text -

Biff I dont know whats going on in excel but I tried your formula on a
sheet and A1 did'nt come up I changed the numbers on '1' and it
worked..... thanks

 

[T. Valko]

You're welcome!

Biff

Biff I dont know whats going on in excel but I tried your formula on a
sheet and A1 did'nt come up I changed the numbers on '1' and it
worked..... thanks