Find precentage result
 

Calcutating the following

=H70*I70*N70
returns
211.20

I want to calculate the precentage carriage based on the value of M7

M7 contains 112.00

This should be I think 53%

what do I need to change in the formula

Thanks for helping
Pat

Find precentage result
 

=(M7/(H70*I70*N70))*100

-via135

Pat Wrote:
Calcutating the following

=H70*I70*N70
returns
211.20

I want to calculate the precentage carriage based on the value of M7

M7 contains 112.00

This should be I think 53%

what do I need to change in the formula

Thanks for helping
Pat


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=524881