Formula Question - Please Help

[gamecock22]

Hey, I was just wondering if anyone could help me with a function that I'm trying to put into a spreadsheet.

This is what I'm trying to do:

I want Column E to add the value from Column C IF column D reads "win" and if column D reads "loss" I want column E to subtract the value from Column A.

Id appreciate if anyone could help me out.

thanks in advance.

[khamilton]

assuming D is either going to be win or loss you could use =if(D?="Win",sum(A?,C?),sum(A?-C?)

[JBeaucaire]

Maybe this in E1, then copied down:

=IF(D1="Win", A1+C1, A1-C1)

EDIT:
Tip of the hat to KHamilton, same basic idea.