christshis
New Member
- Joined
- May 9, 2004
- Messages
- 12
Changed a formula from quatro pro to Excel. But formula did not convert.
I would like a formula that will read:
If C10=0, or if D10=0, then =(C11-D11)/D11-1
My problem is, when a Zero is in one of the columns, it gives me an error message.
In quattro, the formula was :
@IF(C10=0#OR#D10=,(C10-D10), (C10/D10)-1)
Any help to have the same result in EXCEL? Thank you.
I would like a formula that will read:
If C10=0, or if D10=0, then =(C11-D11)/D11-1
My problem is, when a Zero is in one of the columns, it gives me an error message.
In quattro, the formula was :
@IF(C10=0#OR#D10=,(C10-D10), (C10/D10)-1)
Any help to have the same result in EXCEL? Thank you.