=IF(((Sheet1!E6=quot;xquot;)*OR(Sheet1!F6=quot;xquot;)*OR(E6=quot;xquot;)* OR(F6=quot;xquot;)),quot;xquot;,(IF((E6=Sheet1!E6)*AND(F6=Sheet1!F 6),3,(IF((E6-F6)=(Sheet1!E6-Sheet1!F6),2,(IF((SIGN(E6-F6))=(SIGN(Sheet1!E6-Sheet1!F6)),1,0)))))))
- May 16 Wed 2007 20:37
How do i get the if statement i nthis formula to work
- May 16 Wed 2007 20:37
retain formatting as an actual value
Hello,
I have a cell value formatted as Accounting 0000000000 (10 places). How can
- May 16 Wed 2007 20:37
Trouble Forecasting
Not only trouble with Excel, but with Maths I fear.
- May 16 Wed 2007 20:37
how to implement xbrl
Hoy ti get ID to download Microsoft XBRL for Office?
- May 16 Wed 2007 20:37
Cell Address
How can I retrieve the address of a cell in a A1 format?
Example: I have a cell that has something like 28.010D. How can I use a
- May 16 Wed 2007 20:37
Force function to show positive or negative number?
I'm using the following function in a spreadsheet, and it works fine as
long as the number is a positive number. However, if the number is a
- May 16 Wed 2007 20:37
Excel User Conference
Registration Giveaway
- May 16 Wed 2007 20:37
Cannot open file
I have a file afew folders deep in my c: drive named quot;Used for May
BirthdaysJSmithquot; without the parenthesis. When I double-click to open it,
- May 16 Wed 2007 20:37
formula calculation
Is there a way to setup multiple formulas so they calculate in a specific
order?
- May 16 Wed 2007 20:37
Re numbering the row.
Is there a way to re number a row, were row number 1 would move down to the
next row to row number 2. Row number 2 would be moved to row number 3 and so