Screenshot_1.png
Hello friends,
with reference to the image attached How do I make the amount automatically round off. Example Under subtotal column (J) I have entered 3204 and in L column the amount si displayed 3204.00 + 12.36%= 3600.01 how do I make it display 3600.00 (round off)
Like wise for any cell if the the amount is 3400.49 it should automatically display 3400.00 if it is displayed as 3400.51 than it should display as 3401.00
So like wise if the last two units are below .50 it has to be deducted if it is fromk .51 to .99 the remaining amount should be added and the display amount should display round off.
Please help me guys..
Bookmarks