Assuming "Cell 1" is A1
=IF(A1=1,A1+B2,IF(A1=2,E1+B2+C3,""))
--
Rob van Gelder -
http://www.vangelder.co.nz/excel
"karlo " wrote in message
...
hi, would it be possible to have a cell that changes formulas depending
on the result of a certain cell (without using Validationlist).
eg.
if Cell 1 = 1 Cell 2 would apply the formula A1+B2
and if Cell 1 = 2 Cell 2 would apply the formula E1+B2+C3
thanks a bunch
---
Message posted from http://www.ExcelForum.com/