| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Literal based on Week end
I tried these to NO avail:
Cell D51 contains a formula - =TEXT(B51,"dddd") For Cell E51 I want to enter an IF condition based upon the Weekday value in Cell D51. So, here is what I have tried and I also have tried some other variations: 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged") 2. IF(D51='Sunday' OR D51= 'Saturday','No Hours Recorded','Charged') All failed, could anyone pinpoint and corrected the typo? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number to words literal | Excel Worksheet Functions | |||
| Return dates based on month and day of week | Excel Worksheet Functions | |||
| How to use literal quotes with concatenation | Excel Discussion (Misc queries) | |||
| 52 week average based on date | Excel Discussion (Misc queries) | |||
| Referencing Literal Arrays | Excel Worksheet Functions | |||
Threaded Mode
