| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Any suggestions?
Don't use the space bar to clear B1. Text will cause an error with a math operator. Or else use something like =IF(LEN(TRIM(B1))=0,D1,B1) - A1 In article , Debbie wrote: Sounds good but it's giving me a VALUE error? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating interest on number of days in the period | Excel Worksheet Functions | |||
| Calculating for number of days when values are in dates | Excel Worksheet Functions | |||
| How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
| Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
| Total number of each month in a column of dates | Excel Worksheet Functions | |||
Threaded Mode
