If statement in excel

S

siva

Folks-

I need your help in preparing an evaluation sheet...

A B

1 Total 75
2 Completed task A Yes
3 Completed task B Yes
4 Completed task C Yes

5 Total score based on task X


Given above is an example of how the sheet looks consider A as the row
and the numbers in the side as coloumn.

B1 has the value of the total score by measuring some other tasks. But
B5 will contain the actual score of an individual after measuring the
3 main task mentioned in A2, A3, A4.

I want the Total score in B5 to be reduced by 25 if any one value in
A2 or A3 or A4 is changed to "NO"

For example if all A2, A3, A4 or selected as "NO", the total score
should be reduced by 75.

Please help me out in getting a formula to be put in B5.

Thanks,
Sivaji
 
J

johnnykunst

I'm not clear on the layout- if collumn b contains a Yes or No, and b 5 is the result you need this
=B3-((COUNTIF(B4:B6,"No")*25)

If A2:A3 contains not just the yes or no but the whole text, then you need this
=B3-((COUNTIF(B4:B6,"*No*")*25))
 
S

siva

I'm not clear on the layout- if collumn b contains a Yes or No, and b 5 is the result you need this:
=B3-((COUNTIF(B4:B6,"No")*25))

If A2:A3 contains not just the yes or no but the whole text, then you need this:
=B3-((COUNTIF(B4:B6,"*No*")*25))

Hi Buddy,

Thanks a lot for your help... You gave me exactly want i want... It's
working awesome...

Once again thanks a lot for your formula.

Thank u,
Sivaji
 
J

johnnykunst

Glad it's working for you- I've had lots of help on here learning VBA so I'm more than happy to put something back
Cheers, John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top