| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Function that returns a percentage
Hi,
Try this with the cell formatted as percent =IF(I395=0,1,I396/I395) Mike "Zach" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Function that returns a percentage
=IF(I395=0,1,I396/I395) and format the cell as %
"Zach" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function returns function statement rather than result | Excel Worksheet Functions | |||
| IF(AND(OR function returns #VALUE! error | Excel Worksheet Functions | |||
| INT Function Returns 1 | Excel Worksheet Functions | |||
| Function that Returns Worksheet Name | Excel Discussion (Misc queries) | |||
| If function that returns value in a cell. | Excel Worksheet Functions | |||
Linear Mode
