If statement in excel

  • Thread starter Thread starter siva
  • Start date Start date
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
 
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))
 
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))
Click to expand...

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
 
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
 
Back
Top