=IF($B2="","",INT($B2-(C2*C1)/D$1))

"Bhavesh Valand" wrote:

Hi All

I just working through a formula to breakdown salary i.e 50's 20's 10's ...

First 50's Formula =IF($B2="","",INT($B2/C$1))

Second 20's Formula
=IF($B2="","",INT(($B2-SUMPRODUCT(($C2:C2)*($C$1:C$1)))/D$1))

But this formula does not work with some instances. Please check the
attached excel worksheet for example.

Regards
Bhavesh