if functions-adding them together

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been trying to write a formula that evaluates separately several series
of numbers and what I came up with is a formula like this:

=IF(AND(L8<8000,SUM(B8:L8)<8000),L8*$B$72,IF(SUM(B8:K8)>8000,0,((SUM(B8:K8)-8000)*-$B$72))+IF(AND(L17<8000,SUM(B17:L17)<8000),L17*$B$72,IF(SUM(B17:K17)>8000,0,((SUM(B17:K17))-8000)*-$B$72))+IF(AND(L26<8000,SUM(B26:L26)<8000),L26*$B$72,IF(SUM(B26:K26)>8000,0,((SUM(B26:K26))-8000)*-$B$72))+IF(AND(L35<8000,SUM(B35:L35)<8000),L35*$B$72,IF(SUM(B35:K35)>8000,0,(SUM(B35:K35)-8000)*-$B$72))+IF(AND(L44<8000,SUM(B44:L44)<8000),L44*$B$72,IF(SUM(B44:K44)>8000,0,((SUM(B44:K44))-8000)*-$B$72))+IF(AND(L53<8000,SUM(B53:L53)<8000),L53*$B$72,IF(SUM(B53:K53)>8000,0,(SUM(B53:K53)-8000)*-$B$72)))

What I was hoping for was that the first "if statement" would be answered,
then the second, etc. What actually happens is that if the any of the "if
statements" result in 0, then the formula just quits and doesn't continue
evaluating the remaining "if statements". What am I doing wrong?

Thanks for your help!
 
That sort of looks like Excel. Have you tried an Excel news group??

--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer

questionsforms said:
I've been trying to write a formula that evaluates separately several series
of numbers and what I came up with is a formula like this:
Click to expand...
=IF(AND(L8<8000,SUM(B8:L8)<8000),L8*$B$72,IF(SUM(B8:K8)>8000,0,((SUM(B8:K8)-8000)*-$B$72))+I
F(AND(L17<8000,SUM(B17:L17)<8000),L17*$B$72,IF(SUM(B17:K17)>8000,0,((SUM(B17:K17))-8000)*-$B
$72))+IF(AND(L26<8000,SUM(B26:L26)<8000),L26*$B$72,IF(SUM(B26:K26)>8000,0,((SUM(B26:K26))-80
00)*-$B$72))+IF(AND(L35<8000,SUM(B35:L35)<8000),L35*$B$72,IF(SUM(B35:K35)>8000,0,(SUM(B35:K3
5)-8000)*-$B$72))+IF(AND(L44<8000,SUM(B44:L44)<8000),L44*$B$72,IF(SUM(B44:K44)>8000,0,((SUM(
 
Suggest you post this to the Excel newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Back
Top