I need Excel Expert Help

[NightRock]

Kanina pa nasakit ulo ko dito sa simple percentage formula

Export = 7047.5
Production =5585.2

Difference = 1462.4

So basically alam ko na may problema ang metering kasi mas lamang ang export sa production. Gusto ko ma kuha ang percentage ng error.

I tried this formula =(7047.5-5585.2)/5585.2)*100 and it comes 26.18%
Same like this =(7047.5-5585.2)/ABS(5585.2) also got 26.18%

I got confused????? with this 7047.5*20.75% = 1462.4

Ano ba tamang formula what I need is percentage ng error...yung 1462.4 is what percent of 7047.5

[jut703]

Bro, 1462 is 20% of 7047, while it's 26% of 5585.

Diba ang hinahanap mo is how much surplus was exported compared to how much you produced? Edi dapat ang base mo is 5585. So you exported 26% more than you produced.


Posted via Tsikot Mobile App

[confused shoes]

yung 1462.4 is what percent of 7047.5

=1462.5/7047.5 =___ x 100 = ___%


if you are looking for per cent excess, then that would be

= 1462.5/5585.2 =___ x 100 = ___%

[slapz]

math tutor ata kailangan, hindi excel expert.

[Walter]

He needs more than a math tutor, how can they export more than what they produced?

[rangeles]

TS must have some inventory on hand from the previous months maybe thus he export more than what he produced.

Sent from my Samsung Galaxy S4 using Tapatalk 4

[NightRock]

math tutor ata kailangan, hindi excel expert.

Thanks bro given na nga na wrong figure yung produced kasi wrong calibration of device mas accurate yung export figure kasi fixed volume. Finally I got the right formula in excel

[NightRock]

yung 1462.4 is what percent of 7047.5

=1462.5/7047.5 =___ x 100 = ___%


if you are looking for per cent excess, then that would be

= 1462.5/5585.2 =___ x 100 = ___%

Sakto yung first formula hehehe i know the answer pero nag ka gulo gulo formula ko sa dami ng links sa excel thanks