Hi, I think I have an easy question for someone out there. I have a very basic formula in B71. All it does is = B83/15/4. Then I formatted the cell B71 to fractions as halves ½. If the number in B82 is 15 or greater it works fine but 1 to 14 returns a zero.
My question, how can I have that formula work but also add that the minimum output is ½? Zero in B83 is then 0 in B71.
So if in B83 then in B71
0 0
1-14 ½
15 or greater Actual
Any help would be greatly appreciated.
Bookmarks