Here's an example: =IF(A1=2,B1,C1)

Dave
--
Brevity is the soul of wit.


" wrote:

How can I have a formula include data when applicable and at the same time
when that cell does not apply to have it default to another cell to calculate
a sum ?