Hello,
I have this formual in a cell =D2/(100%-60%)+D2/(100%-50%), and the out put I would like it to end in a 9, like $2.09.
Thanks JR
Hello,
I have this formual in a cell =D2/(100%-60%)+D2/(100%-50%), and the out put I would like it to end in a 9, like $2.09.
Thanks JR
To the nearest 9c try
=ROUND(D2/(100%-60%)+D2/(100%-50%)+0.01,1)-0.01
If you always want to round up or down then replace ROUND with ROUNDUP or ROUNDDOWN
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks