Calculation based on lists selected

  • Thread starter Thread starter Supriya
  • Start date Start date
S

Supriya

Hi,

I have validated a cell(Data Validation) where the validation criteria
allows a list and the source is 2 cells containing Y, N.
Now, depending on the list selected, a formula should be calculated.
ie. if Y, (B1+B2)-(A1+A2)
if N, (C1+C2)-(A1+A2)

I have tried a lot but in vain.

Pls help out.
Sups
 
Hi
assuming that your validated cell is A3 and the target cell A4 enter
the following in A4:
=IF(A3="Y",B1+B2-(A1+A2),IF(A3="N",C1+C2-(A1+A2),""))

HTH
Frank
 
Supriya,

Do you just want a formula?

If so, assuming DV is in A1, it is

=IF(A1="Y",(B1+B2)-(A1+A2),(C1+C2)-(A1+A2))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Frank,

If using DV, then it can only be Y or N, so the extra N test is superfluous.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob,

You are right!
If there are only only 2 conditions, there is no need to specify th
2nd one.

It simplified my formula
 
Back
Top