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)

"Supriya " wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/