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/