Respected forum... Good After Noon..
In my attached excel sheet I am using the If formula. First two example are working good..
But after increasing the value it's coming greater than 50000 and I have no knowledge about mixing the CEILING formula with IF formula..
and its answer comes as "91168" bt I want answer in ceiling upto 50000
Bookmarks