I am creating a spreadsheet and am having problems using the if statement. i
am dividing two cells turning that number into a percentage. i am using the
formula =IF(I16=0,0,(E16/C16)) to keep the cell from displaying #div/0! but
now it only displays 0.0%, the number does not change no matter what i put
into E16 or C16. I am also having trouble using the conditional formatting. i
am trying to get the cell to change color depending on what percentage is
displayed in the cell. for example if the percentage is under 40% i want the
cell red, if it is over 40% i want the cell green and i am not sure how to do
this. any input would greatly be appreciated.

hi
your if formula.......
what do you have in I16. if I16 is always zero the the formula will always
say zero regardless of what is in E16 or C16.

conditional format.
condition 1
cell value is......less than or equal to......... .4 ........red

condition 2
cell value is.....greater that............ .4 ...........green


regards
FSt1

"Severance17" wrote:

I am creating a spreadsheet and am having problems using the if statement. i
am dividing two cells turning that number into a percentage. i am using the
formula =IF(I16=0,0,(E16/C16)) to keep the cell from displaying #div/0! but
now it only displays 0.0%, the number does not change no matter what i put
into E16 or C16. I am also having trouble using the conditional formatting. i
am trying to get the cell to change color depending on what percentage is
displayed in the cell. for example if the percentage is under 40% i want the
cell red, if it is over 40% i want the cell green and i am not sure how to do
this. any input would greatly be appreciated.

I16 is a total cell so nothing is in there. i am trying to get E16 and C16 to
divide then put the answer in the I16 cell, but i want the cell to say 0.0%
instead of #div/0! when the answer is 0 and change to 40% or what ever it is
when there is a number there.

"FSt1" wrote:

hi
your if formula.......
what do you have in I16. if I16 is always zero the the formula will always
say zero regardless of what is in E16 or C16.

conditional format.
condition 1
cell value is......less than or equal to......... .4 ........red

condition 2
cell value is.....greater that............ .4 ...........green


regards
FSt1

"Severance17" wrote:

I am creating a spreadsheet and am having problems using the if statement. i
am dividing two cells turning that number into a percentage. i am using the
formula =IF(I16=0,0,(E16/C16)) to keep the cell from displaying #div/0! but
now it only displays 0.0%, the number does not change no matter what i put
into E16 or C16. I am also having trouble using the conditional formatting. i
am trying to get the cell to change color depending on what percentage is
displayed in the cell. for example if the percentage is under 40% i want the
cell red, if it is over 40% i want the cell green and i am not sure how to do
this. any input would greatly be appreciated.

Is your formula wrong?

from
IF(I16=0,0,(E16/C16))
to
IF(C16=0,0,(E16/C16))

Or do you want a check for both I16 and C16

from
IF(I16=0,0,(E16/C16))
to
IF(I16=0,0,if(C16=0,0,(E16/C16)))

"Severance17" wrote:

I16 is a total cell so nothing is in there. i am trying to get E16 and C16 to
divide then put the answer in the I16 cell, but i want the cell to say 0.0%
instead of #div/0! when the answer is 0 and change to 40% or what ever it is
when there is a number there.

"FSt1" wrote:

hi
your if formula.......
what do you have in I16. if I16 is always zero the the formula will always
say zero regardless of what is in E16 or C16.

conditional format.
condition 1
cell value is......less than or equal to......... .4 ........red

condition 2
cell value is.....greater that............ .4 ...........green


regards
FSt1

"Severance17" wrote:

I am creating a spreadsheet and am having problems using the if statement. i
am dividing two cells turning that number into a percentage. i am using the
formula =IF(I16=0,0,(E16/C16)) to keep the cell from displaying #div/0! but
now it only displays 0.0%, the number does not change no matter what i put
into E16 or C16. I am also having trouble using the conditional formatting. i
am trying to get the cell to change color depending on what percentage is
displayed in the cell. for example if the percentage is under 40% i want the
cell red, if it is over 40% i want the cell green and i am not sure how to do
this. any input would greatly be appreciated.

i want the formula to be =E16/C16 but when E16 is 0 and C16 is 0 I16 says
#div/0! and i want I16 to say 0.0% when E16 and C16 are 0.

"Joel" wrote:

Is your formula wrong?

from
IF(I16=0,0,(E16/C16))
to
IF(C16=0,0,(E16/C16))

Or do you want a check for both I16 and C16

from
IF(I16=0,0,(E16/C16))
to
IF(I16=0,0,if(C16=0,0,(E16/C16)))

"Severance17" wrote:

I16 is a total cell so nothing is in there. i am trying to get E16 and C16 to
divide then put the answer in the I16 cell, but i want the cell to say 0.0%
instead of #div/0! when the answer is 0 and change to 40% or what ever it is
when there is a number there.

"FSt1" wrote:

hi
your if formula.......
what do you have in I16. if I16 is always zero the the formula will always
say zero regardless of what is in E16 or C16.

conditional format.
condition 1
cell value is......less than or equal to......... .4 ........red

condition 2
cell value is.....greater that............ .4 ...........green


regards
FSt1

"Severance17" wrote:

I am creating a spreadsheet and am having problems using the if statement. i
am dividing two cells turning that number into a percentage. i am using the
formula =IF(I16=0,0,(E16/C16)) to keep the cell from displaying #div/0! but
now it only displays 0.0%, the number does not change no matter what i put
into E16 or C16. I am also having trouble using the conditional formatting. i
am trying to get the cell to change color depending on what percentage is
displayed in the cell. for example if the percentage is under 40% i want the
cell red, if it is over 40% i want the cell green and i am not sure how to do
this. any input would greatly be appreciated.

Does anyone have any more information for me? I still have not solved my
problem yet.

Assuming that this formula is entered into I16, and I16 is formatted to
percent:

=if(c16=0,0,e16/c16)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Severance17" wrote in message
...
Does anyone have any more information for me? I still have not solved my
problem yet.