yes / no formulas into 1/0


T

The snow Queen

Hello all i have seen that a person has asked if this can be done as a block
of three but i would like to do this on a larger scale will the formula
still fit. to count the yes's as 1.
 
Ad

Advertisements

P

Pete_UK

Don't know what formula you are referring to, but try this:

=COUNTIF(range,"Yes")

Hope this helps.

Pete
 
N

NoodNutt

G'day Pete

I could be wrong , but I think the OL' Snow Queen is possibly referring more
to a true/false.

=IF(A1="Yes",1,0)

Regards
Mark.
 
Ad

Advertisements

D

Dave Peterson

If that's true, then here's another formula:

=--(A1="yes")

A1="Yes"
returns true or false
-true or -false returns -1 or -0 (0)
and
--1 or --0 returns 1 or 0
 

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

Top