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
Tim - Oct 24, 2013 at 07:30 AM
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 21, 2013 at 07:19 AM
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.
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.
Oct 24, 2013 at 07:30 AM