| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula returnsas "1" even with nothing to solve for?
-- Question-- I used the count function to determine the number of time check dates go beyond term limit. I have not even encoded check dates already cell returns "1"? "=COUNT(P2-H2J2)+(S2-H2J2)+(V2-H2J2)+(Y2-H2J2)+(AB2-H2J2)+ (AE2-H2J2)+(AH2-H2J2)+(AK2-H2J2)+(AN2-H2J2)+(AQ2-H2J2)+ (AT2-H2J2)+(AW2-H2J2)+(AZ2-H2J2)+(BC2-H2J2)+(BF2-H2J2)+ (BI2-H2J2)+(BL2-H2J2)+(BO2-H2J2)+(BR2-H2J2)+(BU2-H2J2)+ (BX2-H2J2)+(CA2-H2J2)+(CD2-H265)+(CG2-H2J2)" Whe H2 is invoice date J2 is term limit joromajr |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "too many different cell formats". How to solve this problem? | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| How do I solve "too many different cell formats" in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
