Formula
 

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:

IF E7 IS 80% =C7

Formula
 

What happens when E7 is not 80%? The following formula will assume that you
want nothing to show.

=if(e7=.8,c7,"")

"phardy" wrote:

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:

IF E7 IS 80% =C7

Formula
 

yes if e7 is not 80% then nothing will be in the cell. I will try this thanks
for you help!

"Brad" wrote:

What happens when E7 is not 80%? The following formula will assume that you
want nothing to show.

=if(e7=.8,c7,"")

"phardy" wrote:

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:

IF E7 IS 80% =C7

Formula
 

the 80% formula worked. when i try to change to 100% is does not work? I
think I might be typing it in correct this is how i have it

=IF(E7=0.10,C7,"") is this wrong?

"Brad" wrote:

What happens when E7 is not 80%? The following formula will assume that you
want nothing to show.

=if(e7=.8,c7,"")

"phardy" wrote:

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:

IF E7 IS 80% =C7

Formula
 

What you have in the formula is if E7 is 10% show the value of C7 else show
nothing.

If you want the information in C7 to show up if the value of E7 is 80% or
more you can put in the following

=if(E7=.8,C7,"")



"phardy" wrote:

the 80% formula worked. when i try to change to 100% is does not work? I
think I might be typing it in correct this is how i have it

=IF(E7=0.10,C7,"") is this wrong?

"Brad" wrote:

What happens when E7 is not 80%? The following formula will assume that you
want nothing to show.

=if(e7=.8,c7,"")

"phardy" wrote:

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:

IF E7 IS 80% =C7

Formula
 

Yes. You are wrong, and it's a question of your understanding of numbers,
not of Excel.
100% is 1.0, not 0.1
--
David Biddulph

"phardy" wrote in message
...
the 80% formula worked. when i try to change to 100% is does not work? I
think I might be typing it in correct this is how i have it

=IF(E7=0.10,C7,"") is this wrong?

"Brad" wrote:

What happens when E7 is not 80%? The following formula will assume that
you
want nothing to show.

=if(e7=.8,c7,"")

"phardy" wrote:

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE
FOLLOWING:

IF E7 IS 80% =C7

Formula
 

100% would be 1, not 0.10

=IF(E7=1,C7,"")


Gord Dibben MS Excel MVP

On Tue, 11 Dec 2007 09:06:07 -0800, phardy
wrote:

the 80% formula worked. when i try to change to 100% is does not work? I
think I might be typing it in correct this is how i have it

=IF(E7=0.10,C7,"") is this wrong?

"Brad" wrote:

What happens when E7 is not 80%? The following formula will assume that you
want nothing to show.

=if(e7=.8,c7,"")

"phardy" wrote:

I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:

IF E7 IS 80% =C7