Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
I AM TRYING TO RIGHT A FORMULA AND NEED HELP THE FORMULA IS THE FOLLOWING:
IF E7 IS 80% =C7 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|