Long "IF" formula

  • Thread starter Thread starter NotExcelingNow
  • Start date Start date
N

NotExcelingNow

I thought I would post part of the formula that you all have helped me with
just to say thank you.

I got everything running now.

There were 7 formulas like this one plus 2 data tables one of which had 12
"TRUE" formulas

=ROUND(IF(O63=TRUE,AVERAGE(P45:Q46),IF(D61=TRUE,AVERAGE(P44:Q46),IF(E61=TRUE,AVERAGE(P43:Q46),IF(F61=TRUE,AVERAGE(P42:Q46),IF(G61=TRUE,AVERAGE(P41:Q46),IF(H61=TRUE,AVERAGE(P40:Q46),P46)))))),0)

=AND(M63=TRUE,H46=H45,H45=H44,H44=H43,H43=H42,H41=H42,H41=H40)

=IF(O63=TRUE,"The average ",IF(D61=TRUE,"The average ",IF(E61=TRUE,"The
average ",IF(F61=TRUE,"The average ",IF(G61=TRUE,"The average
",IF(H61=TRUE,"The average ","The "))))))

I got everything running just like I wanted, thank you sooo much!
 
You can make those formulas shorter by eliminating all the =TRUE expressions
*IF* the only possible variables are either TRUE or FALSE.

It looks like you could use an OR function in your last example:

=IF(OR(O63,D61,E61,F61,G61,H61),"The average ","The ")
 
I just started messing with "IF" and "TRUE" formulas yesterday. My company
had a form that was not performing properly. So I took the original formula
and corrected it best I could. Im just glad I got it to work. if I
eliminate the =true statement then I have to put the formula that made that
statement true into the formula. I made the form calculate the avg based on
a fluctuation of the number of values give & on the values themselves. I
have no idea how to use the "or" functions, like I said I just started this
kind of programing yesterday. LOL
 
if I eliminate the =true statement then I have to put the
formula that made that statement true into the formula.
Click to expand...

No. From my understanding all those referenced cells already contain either
TRUE or FALSE. The result of the logical test will also be either TRUE of
FALSE so testing for either is redundant. For example:

O63 = TRUE

=IF(O63=TRUE,......

Evaluates to TRUE like this:

TRUE=TRUE=TRUE

You will get the same result using just:

=IF(063,........

Which evaluates to TRUE like this:

TRUE=TRUE
 
P.S.

While my explanation is TRUE <g>....

If it helps you follow the logic of what the formula is doing the way you
have it then that's all that counts!
 
My mistake, I dont think they were "TRUE" formulas. the formula refers back
to the "AND" formulas. So if the AND formula was true then ......., if false
then it would go to the next "AND" formula and so on.
 
Back
Top