conditional formulas

[karlo]

hi, would it be possible to have a cell that changes formulas dependin
on the result of a certain cell (without using Validation>list).

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 bunc

 

[Rob van Gelder]

Assuming "Cell 1" is A1
=IF(A1=1,A1+B2,IF(A1=2,E1+B2+C3,""))

 

[Nicky]

Hi
Try this

=IF(A1=1,A1+B2,IF(A1=2,E1+B2+C3,"not 1 one or 2")

 

[karlo]

thanks a lot!! now for my other problems: