Forum Discussion

Copper Contributor

Aug 15, 2019

QUOTIENTS

IF i WANT TO DIVIDE A NUMERATOR BY ONLY THE NUMBER OF CELLS THAT HAVE AN ENTRY (WHICH CAN VARY), HOW WOULD I DO THAT?

Silver Contributor

Aug 15, 2019

Hi,

Supposing that the entry is 10 and the numerator is 20, you can do that using the formula below.

=IF(A1=10,20/A1,"")

Regards