I want do round off decimal figure in sum digit ex. 100.17 ans is 100.18 ex. 100.22 ans is 100.22 ex. 100.23 ans is 100.24 ex. 100.15 ans is 100.16 SO Which formula i use for my decimal point will round off in sum figure Plz reply....
NO such formula exists....... since u want increment by 0.01.......simply add it to your formula........... Tally's ROUND formula will not round 100.17 to 100.18
Dear Sir One user use 3 decimal But they need to print 2 decimal for Ex: 100.835 they required 100.80 100.855 they required 100.90 100.850 required 100.90 How it is possible, if any body having solution pls shared with me. trichytally@gmail.com Thanking you.
Another way........ Convert number / amount to string........ Use Stringlength to derive the last 2 or 3 numbers....... use formula to check and if less than 5 then o, and if more than 5 then increment previous number.......... then convert back and use this number / amount.