Hello,
I have a table where I want a formula in cell C2 to divide the amount in A2 (e.g. by 4) if populated, or if blank to divide the amount in cell B2 instead.
[TABLE="border: 0, cellpadding: 0, cellspacing: 0"]
[TD="width: 23"] [/TD]
[TD="width: 58"]A[/TD]
[TD="width: 49"]B[/TD]
[TD="width: 75"]C[/TD]
1
[/td]CAT 1
[/td]CAT2
[/td]1Q
[/td]2
[/td]100
[/td]3
[/td]125
[/td]
[/TABLE]
Anybody have any ideas how I can accomplish this?
Thanks in advance,
zdjbel