Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If AND Statement
I have a number in Cell A1 and A2 for example.
I want a formula that says, that IF A1 and A2 are both Zero, then to place a zero in the the cell, if false divide A1/A2. Here is the formula i used but it obviously doesn't work =IF(A1=0 and A2=0,0,A1/A2) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Specific Cell Content using IF Statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) |