YES OR NO...IF SO....Solved/Closed

Question

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.

Mazzaropi · Answer

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.

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

1 reply

Subscribe To Our Newsletter!