It wasn't that difficult to track down!!

http://www.microsoft.com/office/comm...0-7454f7626c94

"sunnydazy" wrote:

Hello;
I sent in a question this morning but it seems to have disappeared. it is an
if and then situation. this was the first response, but it didn't work.

=IF(E1=1,J1+J5,IF(E1=2,J1+J6,""))

if cell E1=1 then add cell J1 to cell J5
if cell E1=2 then add cell J1 to cell J6

thank you for your help,

Sunnydazy