formula for proportionating the amount

[sambashivamk]

Hi All,

I have applied the formula for calcuating proportionate amount that needs to be porportionated between fruits and vegitables, but for few cases its not giving the desired result (which is highlighted in the sample sheet). Column J (manual result) should match with Colomum E (formula cell). Pls help.

Regads,
Shiva

 

[lohithsriram]

Hi Sambashivamk,

Sample sheet, as you mentioned is not attached. Attach it for us to help you.