| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If statements
This must have been solved already.
I want to compare budget(cell a) and actual(cell b) columns and display a percentage result in an adjacent cell(cell c). If either cell a or cell b is 0, I want cell c to display either: "n/a" or "0" or be blank. |
|
#2
|
|||
|
|||
|
One way
=IF(A1=0,0,IF(B1=0,0,B1/A1)) Ian "df1234" wrote in message ... This must have been solved already. I want to compare budget(cell a) and actual(cell b) columns and display a percentage result in an adjacent cell(cell c). If either cell a or cell b is 0, I want cell c to display either: "n/a" or "0" or be blank. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical ELSE statements | Excel Discussion (Misc queries) | |||
| More than 7 IF statements in one arguement | Excel Worksheet Functions | |||
| Nested IF statements | Excel Worksheet Functions | |||
| Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
| If statements | Excel Worksheet Functions | |||
Linear Mode
