There's no attached spreadsheet in discussion groups. Explain what doesn't
work, what errors you're getting, etc.

Dave
--
Brevity is the soul of wit.


"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