Is there a way to program a cell to automatically round a number up or down if the number being rounded is a sum of other numbers? I'd like to be able to round this $1.22 either up or down in $0.25 cent increments.
Example:
=sum($0.15+$1.07)=$1.22
Is there a way to program a cell to automatically round a number up or down if the number being rounded is a sum of other numbers? I'd like to be able to round this $1.22 either up or down in $0.25 cent increments.
Example:
=sum($0.15+$1.07)=$1.22
Assuming you are summing A1 & B1 try
=ROUND(SUM(A1:B1)*4,0)/4
Thank you much,Originally Posted by daddylonglegs
Works just fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks