IF statements terribly frustrated!
It is kinda confusing to me
"Ron Coderre" wrote:
Let's see if I understand you correctly.....
With
A1: 5
B1: 10
C1: 13
D1: 15
The sum is 43,
but
Number 15 is greater than 13...so add 1
Number 5 and 10 are less than 13....so subtract 2*2 (4)
Final total = 43+1-4=40
If that's correct, than
E1: =SUM(A1:D1)+COUNTIF(A1:D1,"13")-COUNTIF(A1:D1,"<13")*2
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Mandy" wrote:
I have a question, I am trying to work on a grade book spread sheet and I am
having no luck.
If a number is more than 13 in a box then it should ad 1 to each number over.
If a nubme is less than 13 then there is a 2 point deduction for each number.
I think I need to use a if then statement right?
|