View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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/