jd_9009

Level 1 (4 points)

iWork

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

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

I have this question too

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

All replies

Helpful answers

by Yellowbox,

Yellowbox Aug 24, 2016 12:40 AM in response to jd_9009
Level 6 (10,550 points)

Mac OS X

Aug 24, 2016 12:40 AM in response to jd_9009

Hi jd,
One way, with Checkboxes,
Formula in D3 (and Fill Down)
=IF(B2,C2×0.2,C2)

Regards,
Ian.
Reply options

Link to this post

by Wayne Contello,

Wayne Contello Aug 24, 2016 5:17 AM in response to Yellowbox
Level 6 (19,421 points)

iWork

Aug 24, 2016 5:17 AM in response to Yellowbox

Another , yet similar, way:
=IF(B2,0.2,1)*C2
Reply options

Link to this post

by Yellowbox,

Yellowbox Aug 24, 2016 8:37 AM in response to Wayne Contello
Level 6 (10,550 points)

Mac OS X

Aug 24, 2016 8:37 AM in response to Wayne Contello
Reply options

Link to this post

by Yellowbox,

Yellowbox Aug 24, 2016 8:41 AM in response to Yellowbox
Level 6 (10,550 points)

Mac OS X

Aug 24, 2016 8:41 AM in response to Yellowbox

Edit:
Silly me .
Formula in D3 D2 (and Fill Down)
=IF(B2,C2×0.2,C2)
Ian.
Reply options

Link to this post