using another funtions with dividing numbers

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
Hi,
I've tried to google this but all the answer goes to the same obvious answer; to divide c/b, you click on cell b, the divide and then cell b, taraaaaa. Well, as far as I know QUOTIENT function is used to divide numbers in Excel, but it only gives you whole numbers. So if I need to use it to perfom this calculation monthly, in which case I need something more ambivalent that c1/c2.....though I tried it after countif, but of course it didn't work. Any ideas I will be much appreciated
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Can you elaborate with examples of input and results, and also why c1/c2 is "not ambivalent enough"?
 

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
Hi NBVC,

I found a way with formula =IF(Q1880="","",SUM(IF(Q1874:Q1893<>0,L1874:L1893/Q1874:Q1893))).

I wanted to put the "if" formula to make blank cells blank,and for this I needed a formula, other than just press "L1874", then "/", and then "QL1874". I have seen similar queries but people always get like; what a simple question.......so easy; L/Q! There is also a function called QUOIENT for divisions but only gives you whole numbers, not the interger. Thank you
 
Top