The formula is: =iferror(round(($d$8*$i$3)/(countif($c$18: $xfd$18,"> 0")*$l$3),1)& " times! ","") $d$8 = 36 $i$3 = 2000 $c$18: $xfd$18 = 477 $l$3 = 5000 in excel i get 4.7 but when i calculate it i get 2.96. what am i doing wrong?

Ask your question to the AI advisor

Ai-bot is an expert in any field and is the perfect companion for reliable and useful answers and advice on a variety of topics, including science, history, technology, art, sports, health, culture and more.