Hello Team....Numbers 'IF' formula...HELP

Question

Level 1

5 points

Hello all,

I am a little embarrassed to ask but whats the formula in Numbers to ask

IF X = True then Multiply Y by 0.2

I have tried a few variations but can't get the formula to stick

Thanks in advance

Jd

MacBook Pro (Retina, Mid 2012), iOS 6.1.4

Posted on Aug 24, 2016 12:29 AM

Reply

Answer 1

Level 7

21,987 points

Hi jd,

One way, with Checkboxes,

Formula in D3 (and Fill Down)

=IF(B2,C2×0.2,C2)

Regards,

Ian.

Reply

Answer 2

Another , yet similar, way:

=IF(B2,0.2,1)*C2

Reply

Answer 3

Level 7

21,987 points

🙂

Reply

Answer 4

Level 7

21,987 points

Edit:

Silly me 😊.

Formula in D3 D2 (and Fill Down)

=IF(B2,C2×0.2,C2)

Ian.

Reply