Profit Ratio in Excel

[Sarfraz Khan]

Dear Sir,

I want an excel formula for if the Investment amount is Rs 784375/- and Profit is Rs 41954/-

Then How much would be the profit if the Investment amount is Rs 100000/-

 

[NARAYANK991]

Hi ,

I have no idea of accounting terminology , but will it be :

=B6 * C5/B5

Narayan