Need Formula

[Wellsy]

Hi, I'm new to OpenOffice so please accept my apologies in advance. I need a formula to calculate a payment

In English - IF A3 says "Yes" the A2 is A1 Divided by 2, IF A3 says "NO" then A2 is 0 (zero)

Any guidance would be appreciated

[Bald Eagle]

If a1 is a number, and A3 is Yes/No,

Just put

Code: Select all

=IF(A3="Yes",A1/2,0)

into A2

[keme]

Code: Select all

=IF(A3="Yes",A1/2,0)

Commas won't work in OpenOffice Calc. Use semicolon.

Code: Select all

=IF(A3="Yes";A1/2;0)