# Help With another formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### quiff

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.

#### Keebellah

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)

#### quiff

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

#### Keebellah

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

#### Pedro15

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

#### Keebellah

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)

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On

### Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

over 807,865 other people just like you!

### Members online

No members online now.