How do you round the product of one cell multiplied by another cell to the nearest $.25?
R Ron Weaver Feb 5, 2004 #1 How do you round the product of one cell multiplied by another cell to the nearest $.25?
F Frank Kabel Feb 5, 2004 #3 Hi Ron one way if you want to multiply A1 and B1: =ROUND((A1*B1)*4,0)/4 Frank
A A.W.J. Ales Feb 5, 2004 #4 As an alternative to Peo's and Frank's solution : =MROUND(A1*A2,0.25) MROUND is a function from the Analysis Toolpak Add-in -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails *
As an alternative to Peo's and Frank's solution : =MROUND(A1*A2,0.25) MROUND is a function from the Analysis Toolpak Add-in -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails *
