Thread: Rand and If
View Single Post
 
Old 01-03-2018, 01:46 PM
piper7971 piper7971 is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default

That works but it occasionally gives me a divisor greater than the dividend resulting in a division that would total a percentage. is there a way that have the formula to always give me a divisor that is always less. This is an example of one of the returns it gave me.
1263 ÷ 2512 = 0.50
Reply With Quote