Same value in one cell with different calculation in Excel

[iqubalemco]

Dear Expert,

Herewith I have attached my requirement example file fir kind reference. Please help.

Thanks & Regards,

[6StringJazzer]

This requirement is not clear. What result do you want?

"The above two estimate amount values are same but my requirment is same amount value in one estimate table with to different calculation
please help with suitable formula function."

You have two identical ranges with the same data and formulas, except the values in M.WAST and WASTAGE.

To get help you will need to explain what these values mean, how the formulas work, and explain your requirement in much more detail. The "same amount value in one estimate table with [two] different calculation" is not meaningful. What result do you want?

Also note in your formula

Please Login or Register  to view this content.

the SUM function is not useful.

Please Login or Register  to view this content.

This formula refers to a row of blank cells so you have 0 as a result.

[iqubalemco]

Dear 6StringJazzer,

My requirement is "J3" cell value result will be the same depending when changes by different calculation with M.WAST and WASTAGE. The both wastage will have same percentage calculation. I want the amount value will be same result. Please help with suitable formula.

I want same amount value in one cell for two estimate calculation. So I want one estimate for both calculation. Please help.

[iqubalemco]

Dear Experts,

Please help any one...

[AliGW]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. If you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.