conditional formulas
 

hi, would it be possible to have a cell that changes formulas dependin
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 bunc

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

conditional formulas
 

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/

conditional formulas
 

Hi
Try this

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

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

conditional formulas
 

thanks a lot!!:) :) :) :) :) :) :) now for my other problems:

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