YES OR NO...IF SO....

Solved/Closed
rbmastertitan
Posts
6
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
November 30, 2013
- Oct 21, 2013 at 04:02 AM
 Tim - Oct 24, 2013 at 07:30 AM
Hi

I need to ask a cell to do two functions.

So if a cell (drop down list) has yes/no...then another cell will.....when yes is selected then divide by 2 a total from another cell, but when no is selected then inout 0..

Any ideas? Many thanks.

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Oct 21, 2013 at 07:19 AM
Good morning.

Suppose:
A1 --> Drop down list cell

B1 --> Content to be divided

C1 --> Formula --> =IF(A1=Yes",B1/2,0)

SCENARIO:
A1 = Yes ; B1= 20
C1 --> as A1 = Yes Then B1/2 = 20/2 = 10

A1 = No ; B1= 20
C1 --> as A1 = No Then = 0

Please, tell us if it worked for you.

I hope it helps.

Greetings from Brazil.
0
Fantastic, Thank-you very much. This works perfectly.
0