Formula not giving the required result

Asked By Tyrone E Louis 130 points N/A Posted on - 02/23/2015

I have been trying out a formula on Excel and I cannot seem to get the required result. I have worked out in a different place twice and I get a different answer to the one I get on excel. Here is the formula:

For A1 4900 and 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)))))))

I believe the answer should be 44.6667 but I get 38.6667 using this formula. Can I get the formula to work as desired?

• Status: Open
• Question Views: 517
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Anyet Thngo 0 points N/A #185222

Formula not giving the required result

Hi Tyrone,

 

The formula will give the expected results when the mathematical calculation is done separately for cells A1 and A2. We have to compute one output based on the value in cell A1 and then do a separate calculation for value of cell A2. The formula is as follows:

 

=(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))))

 

Regards,

Anyet

 

About Anyet Thngo

Questions
3

Answers
81

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/23/2015
• Question Category: MS Excel