Ronda

[rcable]

How can I create the following formula? Sheet 1 Cell B36 = Sheet 2 cell A41 but if A41 is 0 then Cell B36 = A46:

[shg]

Please take a few minutes to read the forum rules, and then start a new thread with an appropriate title in one of the question forums (this isn't one).

Thanks.