Thread
:
If problem...
View Single Post
#
3
Posted to microsoft.public.excel.programming
JLGWhiz
external usenet poster
Posts: 3,986
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!
Reply With Quote
JLGWhiz
View Public Profile
Find all posts by JLGWhiz