IF statement Help

  • Thread starter Thread starter Severance17
  • Start date Start date
S

Severance17

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
 
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
 
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.
 
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.
 
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)))
 
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)))
 
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.
 
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.
 
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)
 
Back
Top