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.