# Help With another formula

Discussion in 'Business Applications' started by quiff, Feb 20, 2015.

Not open for further replies.

Joined:
Jan 28, 2015
Messages:
12
Hi,

A1 4900
A2 4900

=(A1*2+A2)/450+IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0+(IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0)))))))

Should be 44.6667

But I get 38.6667.

Cant get the last bit of the formula to work.

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans
HI, I suggest you split it into different cells.
The answer you get is correct in that sense that once the first IF(A1>4800 is TRUE it adds 6 and that is 38,6667
I tried some other things but I only get 56,6667 so I cannot understand where you expect the 44,6667

=((A1*2+A2)/450)+IF(A1>4800,6,)+IF(A1>2400,4,)+IF(A1>0,2,)+IF(A2>4800,6,)+IF(A2>2400,4,)+IF(A2>0,2,0)

Joined:
Jan 28, 2015
Messages:
12
Hi,

Yeah I understand that the formula works as it should, but I want it to also consider the other if relating to cell A2 then add the appropriate number.

So the first bit of the equation works fine but fine. Then consider the ifs for cell A1 which it does. But then it stops and does not consider adding another 6 regarding cell A2.

Ideally would prefer to keep it to one cell, so if you have any ideas would appreciate.

Regards

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans
You should break up the formula into separate sections
Maybe like this, I don't know, you will have to test
=(A1*2+A2)/450)+IF(A1>4800,6,0) + IF(A1>2400,4,0) + IF(A1>0,2,0) + IF(A2>4800,6,0) + IF(A2>2400,4,0) +IF(A2>0,2,0)
Let me know if it helps some

5. ### Pedro15

Joined:
Oct 5, 2008
Messages:
386
More than one however it works

C1 =IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0))) gives 6
C2 =(IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0))))gives 6
C3 =(A1*2+A2)/450 gives 32.66667
TOTAL 44.66667

Pedro

Joined:
Mar 27, 2008
Messages:
6,608
First Name:
Hans
Have you placed this in one formula?

=IF(A1>4800,6,IF(A1>2400,4,IF(A1>0,2,0))) + (IF(A2>4800,6,IF(A2>2400,4,IF(A2>0,2,0)))) + ((A1*2+A2)/450)

As Seen On