Thread
:
conditional rounding
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
egarcia
external usenet poster
Posts: 13
conditional rounding
My current formula is =ROUNDDOWN(AB15/$AB$36,0). I want to change it to = 0
if it's zero. If the number is between .1 to .9 i want it to equal 1. If it's
greater than 1 I want it to round down. Can u help me?
Reply With Quote
egarcia
View Public Profile
Find all posts by egarcia