IF with #DIV/0!


D

DKY

The first one didnt work papou, but the last one worked. Thank you bot
for the help. I didnt even think of using count
 
Ad

Advertisements

B

BenjieLop

The terms in Papou's formula are separated by a semicolon ";" while tha
of Frank's are by a comma "," so if you replace the semicolon with
comma, Papou's formula should work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#DIV error 5
Windows 10 Itunes/TabKey 0
#Div/0 error, can't get rid of it 8
Jeopardy on Powerpoint 0
PowerPoint Powerpoint Slow Animations 2
Taking Average ignoring #DIV/0! in the range... 1
SUM / COUNT formula 3
#DIV/0! ERROR 2

Top