If Then?

P

picktr

I'm having a problem with an argument.

I'll type it out:

IF worksheet1!B1 has a value
true = copy that value
false = 0

there is a formula in worksheet1 that returns a value
greater than 0 or no value at all - leaves the cell blank.


=IF(E14=1,1/$E$45,"")

I need this formula AS IS with the addition of putting
a value of 0 in the cell : OR something with the IF then above.

Thank
 
D

DNF Karran

If i have understood correctly (if b1 is greater than zero then put th
value from b1 otherwise put zero):

=IF(Sheet1!B1>0,Sheet1!B1,0)

should do
 
Top