Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If problem...
Hi Folks,
I'm trying to say "Cell 3 = If cell 1 & cell 2 = 0 then "" else (cell 1 - cell 2) / cell 2. But I can't get that to work as a fomula. help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
If problem...
Hi,
See below : =IF(AND(A1=0,A2=0),"",(A1-A2)/A2) HTH Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
If problem...
=IF(AND(A1=0, B1=0), "",(A1-B1)/B1)
"Stephen" wrote: Hi Folks, I'm trying to say "Cell 3 = If cell 1 & cell 2 = 0 then "" else (cell 1 - cell 2) / cell 2. But I can't get that to work as a fomula. help! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
If problem...
perfect thank you!
"JLGWhiz" wrote: =IF(AND(A1=0, B1=0), "",(A1-B1)/B1) "Stephen" wrote: Hi Folks, I'm trying to say "Cell 3 = If cell 1 & cell 2 = 0 then "" else (cell 1 - cell 2) / cell 2. But I can't get that to work as a fomula. help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |