Please Help in Excel Fourmula...

[KingKhan84]

Thanks Brother....
Good work...

Sorry for late reply....

Welcome............
The Problem is solved...

[Shaheen Latif]

Thanks for Reply...

Total value 648 -18% for discount = 531.36 - 2% for bonus = 520.73 (is right ans.)
Total Value 648 - 18% for discount = 531.36 ÷ 120% for bonus = 442.80 (is right ans.)

is calculation key hissab sey excel per formula bana dain...

thanks & regards...

Formula
=(648-(648*18%))*98%
=(648-(648*18%))/120%

[KingKhan84]

Pls check this file

But ye khyal rahe jis line ke calculation require ho to COL F to J zaror copy/paste karna kyunke os mai formulas hai

[seven86]

Pls check this file

But ye khyal rahe jis line ke calculation require ho to COL F to J zaror copy/paste karna kyunke os mai formulas hai

Thanks Brother...

[KingKhan84]

Thanks Brother...

You welcome