How would I write a formula that includes the following three stipulations?
If C3 < 0.5: round to the nearest 0.1
If C3 > or = 0.5 to < or = 5.0: Round to the nearest 0.5
If C3 > 5: round to the nearest 1
How would I write a formula that includes the following three stipulations?
If C3 < 0.5: round to the nearest 0.1
If C3 > or = 0.5 to < or = 5.0: Round to the nearest 0.5
If C3 > 5: round to the nearest 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks