decision Box Y
How do i put a formula that recognises a 'yes' or 'no' answer?
e.g X Y Z
1 10,000 No 0.000
If Y1 has 'No' printed in it then 0.000 is printed in Z1
However if 'Y1' has 'yes' printed in it I need a formula of =sum(X1*0.03) to
be completed (see below).
e.g X Y Z
1 10,000 yes 300
Can anybody help?
|