Thread: IF Function that returns a percentage
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zach zach is offline
external usenet poster
  
Posts: 14
Default IF Function that returns a percentage
I am wanting to create a logic test formula that if the cell is equal to zero
then the output would be 100%, if the cell is not zero then I would divide
the cell by another one to get a percent. Here is my formula

IF(I395=0,"100",I396/I395)

It works but I want the number 100 to be stored as a percent so it shows up
on my chart. Any suggestions?


Reply With QuoteReply With Quote