If cell =Yes number value into another cell

**cernst** · 11-01-2011, 06:26 PM

Hello - I am working on a spreadsheet for call monitoring for work and need a value to populate into another cell

example:
If C12 = Yes then D12 = 5
If C12 = No then D12 = -5
IF C12 = N/A then D12 = 5

if this possible?

**tigeravatar** · 11-01-2011, 06:32 PM

cernst,

In cell D12, give this formula a try:
=IF(OR(C12={"Yes","N/A"}),5,IF(C12="No",-5,""))

**cernst** · 11-01-2011, 09:51 PM

Thanks it appears to be working I have been looking at it all night. Is there anyway that if no is selected and the -5 is deducted that if no is selected again between a certain cell range that it will not deduct the -5 again? I am also trying come up with a score for my sheet as we use this for call reviews. When I select no on my spreadsheet the total does not match up for some reason its seems to add the 5 but yet subtract the 5

I attached the sheet I am using hopefully someone can assist me.

Thanks!