If - Then formula

[Mr. McNeill]

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!!!

 

[PCLIVE]

Maye

 

[PCLIVE]

Maybe something like this:

=(COUNTIF(B1:B10,"Yes")*10)+(COUNT(ISNA(B1:B10))*11)

HTH,
Paul

 

[Mr. McNeill]

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!!!!

 

[PCLIVE]

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)


--