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

Thread Starter
Joined
Jan 28, 2015
Messages
12
Hi,


Could you please help with this formula:


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
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
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

Thread Starter
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
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
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
 
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
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
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.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
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.

Join over 807,865 other people just like you!

Latest posts

Members online

No members online now.
Top