Help with multiplying / addition if certain criteria is met.

[johnnymeow2]

Hi, I am fairly new to excel and can not find an answer online.

I basically have data and in column N I want it to basically say IF Column M = W then Column C multiply with Column G but if column M = L then I want Column M to say the Negative version of the number in Column C.

 

[etaf]

=IF( M2="W", C2*G2, IF(M2="L", C2*-1,""))

and copy down

depending on whats in C2 or G2 - its possible you may get and error - which you could then use IFERROR() so it does not show the error or a different message

if for example C2 or G2 contains text

=IFERROR(IF( M2="W", C2*G2, IF(M2="L", C2*-1,"")),"")

This just leave the cell blank if M2 does not equal W or L
if you want something else in that cell, then replace "" with "message"