Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
yes / no formulas into 1/0
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
yes / no formulas into 1/0
Don't know what formula you are referring to, but try this:
=COUNTIF(range,"Yes") Hope this helps. Pete On Jul 4, 9:36*am, The snow Queen <The snow wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
yes / no formulas into 1/0
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
yes / no formulas into 1/0
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 NoodNutt wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |