Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then formula
Hello I'm trying to create a If formula that will count a total if I enter
yes into a cell, but if I enter no into a cell, I need the amount that is counted to be distributed equally throughout a variety of cells.. EX: for 10 cells total amount is 100. If yes is entered into cell beside it the formula counts the cell as 10 if. No the formula counts as 0, and if N/A is entered the formula counts as .11 for the remaining 9 cells used. Any help would be greatly appreciated!!! -- Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then formula
Maye
-- "Mr. McNeill" wrote in message ... Hello I'm trying to create a If formula that will count a total if I enter yes into a cell, but if I enter no into a cell, I need the amount that is counted to be distributed equally throughout a variety of cells.. EX: for 10 cells total amount is 100. If yes is entered into cell beside it the formula counts the cell as 10 if. No the formula counts as 0, and if N/A is entered the formula counts as .11 for the remaining 9 cells used. Any help would be greatly appreciated!!! -- Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then formula
Maybe something like this:
=(COUNTIF(B1:B10,"Yes")*10)+(COUNT(ISNA(B1:B10))*1 1) HTH, Paul -- "Mr. McNeill" wrote in message ... Hello I'm trying to create a If formula that will count a total if I enter yes into a cell, but if I enter no into a cell, I need the amount that is counted to be distributed equally throughout a variety of cells.. EX: for 10 cells total amount is 100. If yes is entered into cell beside it the formula counts the cell as 10 if. No the formula counts as 0, and if N/A is entered the formula counts as .11 for the remaining 9 cells used. Any help would be greatly appreciated!!! -- Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then formula
I tried to ammend my spreadsheet with the formula you gave me and for some
reason I keep coming up with a value of 111 when yes is entered and 101 when no is entered? Also the other cells do not receive any increase in the formula? Thanks for all the help!!!! -- Thanks! "PCLIVE" wrote: Maybe something like this: =(COUNTIF(B1:B10,"Yes")*10)+(COUNT(ISNA(B1:B10))*1 1) HTH, Paul -- "Mr. McNeill" wrote in message ... Hello I'm trying to create a If formula that will count a total if I enter yes into a cell, but if I enter no into a cell, I need the amount that is counted to be distributed equally throughout a variety of cells.. EX: for 10 cells total amount is 100. If yes is entered into cell beside it the formula counts the cell as 10 if. No the formula counts as 0, and if N/A is entered the formula counts as .11 for the remaining 9 cells used. Any help would be greatly appreciated!!! -- Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If - Then formula
What column will it show "yes", "no", or "N/A". I assumed it was column B.
I just realized (I think) my mistake or assumption of your "N/A" reference. I assumed your "N/A" was not an entered value rather an error that displays #N/A. Are these "N/A"s the result of a formula?...or are they actually typed in? Try this one. =(COUNTIF(B1:B10,"Yes")*10)+(COUNTIF(B1:B10,"N/A")*11) -- "Mr. McNeill" wrote in message ... I tried to ammend my spreadsheet with the formula you gave me and for some reason I keep coming up with a value of 111 when yes is entered and 101 when no is entered? Also the other cells do not receive any increase in the formula? Thanks for all the help!!!! -- Thanks! "PCLIVE" wrote: Maybe something like this: =(COUNTIF(B1:B10,"Yes")*10)+(COUNT(ISNA(B1:B10))*1 1) HTH, Paul -- "Mr. McNeill" wrote in message ... Hello I'm trying to create a If formula that will count a total if I enter yes into a cell, but if I enter no into a cell, I need the amount that is counted to be distributed equally throughout a variety of cells.. EX: for 10 cells total amount is 100. If yes is entered into cell beside it the formula counts the cell as 10 if. No the formula counts as 0, and if N/A is entered the formula counts as .11 for the remaining 9 cells used. Any help would be greatly appreciated!!! -- Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|