| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display #'s incorrectly (format)
=IF(AND(H3-O$1<0,M3-O$1<0,H3<M3),"Past due
"&-MAX(H3-O$1,M3-O$1),MAX(H3-O$1,M3-O$1,0)) Formula above works great (Thanks to those that helped), but the problem I'm now having is when account is not past due the other #'s return with serveral 0's. Example:00000 or 00221 I would like 221 to appear verses 00221 or 0 versas 0000 -- Elena |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display #'s incorrectly (format)
I figured it out..
Thanks again -- Elena "Elena" wrote: =IF(AND(H3-O$1<0,M3-O$1<0,H3<M3),"Past due "&-MAX(H3-O$1,M3-O$1),MAX(H3-O$1,M3-O$1,0)) Formula above works great (Thanks to those that helped), but the problem I'm now having is when account is not past due the other #'s return with serveral 0's. Example:00000 or 00221 I would like 221 to appear verses 00221 or 0 versas 0000 -- Elena |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display time format | Excel Discussion (Misc queries) | |||
| How to display 5 into May in mmm format? | Excel Discussion (Misc queries) | |||
| 9200000000000009 display incorrectly. | Excel Discussion (Misc queries) | |||
| Cell format, want 100 to display as 1.00 | Excel Discussion (Misc queries) | |||
| Display 0's in Accounting format | Excel Discussion (Misc queries) | |||
Linear Mode
