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.