Using a formula to give a result of a text answer

[Guest]

Hi

New to this.

I would like to use excel to creat a formula. This formula is something that would be using a Yes or a No answer.

For Example, there are 8 things that need to be done from a person. Once that info is put in I have 3 Yes's and 5 no's, then I want to get the end result to say no.

Then is all those field are all Yes's then I would like that end result giving out the final value of saying yes

Any help is wonderful.

 

[macropod]

Hi Liz,

Suppose your Yes/No answers appear in cells A1:A8 and you want a 'Yes'
result only if all of these cells contain 'Yes'. In that case, the formula:
=if(COUNTIF(A1:A8,"Yes")=8,"Yes","No")
would do the trick.

If you want the 'Yes' result if 4 or more of these cells contain 'Yes', the
formula:
=if(COUNTIF(A1:A8,"Yes")>3,"Yes","No")
would do the trick.

Cheers

Hi!

New to this..

I would like to use excel to creat a formula. This formula is something

that would be using a Yes or a No answer..

For Example, there are 8 things that need to be done from a person. Once

that info is put in I have 3 Yes's and 5 no's, then I want to get the end
result to say no..

Then is all those field are all Yes's then I would like that end result

giving out the final value of saying yes.

 

[Guest]

hay i need to no the tax is a percentage of the total taxable amount what formula would i us
the total taxable amount is 641.812
if you could help it would be awsome

 

[David McRitchie]

Hi Nicola,

= 100 * (portion considered) / (total amount compared to)

If you want to include the % sign you probably want to use the
% key instead of multiplying by 100.

Since you only gave one figure, I'm not really sure that you
asked the question that you wanted to ask. Also ...

Income taxes are calculated at a different rate for each
bracket (layer) of income. Many might consider the
percentage rate of the highest bracket they are in
to be their tax rate. The following formula would
apply to aggregates for income tax. Percentage
is another way of expressing a ratio.

Please start a separate thread for your question, rather than stepping
on someone else's thread. People want to see answers to their
question in the thread they start -- not unrelated questions and
answers.

Please try to use good English with correct capitalization. It makes
it a lot easier for everyone to read. Specifically there are enough
typos made to make things difficult enough without purposely
making errors. A lot of people here don't speak
English as their native language . Please also include your
first and last name so we know who we are talking to and so that
you can look up an answer you received months before if you have to,
by looking in the archives.