Dividing number formula but require a minimum output?

[dawondr]

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.

[Pete_UK]

Try this in B71:

=IF(B83=0,0,IF(B83<15,0.5,B83/15/4))

Hope this helps.

Pete

[popipipo]

=if(a3=0,0,max(15,a3)/15/4)

something like this????

[dawondr]

Pete it worked Perfect, thank you. Pop I didn't try yours but thank you also for responding.

Dave