=A2/if(c0,2,1)
"Admiral70" wrote:
I need to tell column B if there there is something in column C greater
than zero then use column A figure. Otherwise use A/2.
A B C D
Savings Shared Flat fee TOTAL
$52.66 $26.33 $15.00 $15.00
Can anyone help me with this formula?
Thanks in advanced.
|