Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Message for Frank follow on Q from yesterday
Problem with IF and Nested IF
Morning Frank, Not entirely sure what your after Frank; If one looks at Column A below I want to convert them all into weeks format to standardise the data from the different sources. Eg 6 Months and 182 Days (Col A) will become 26 Weeks, 28 Days will become 4 weeks follow this format for all the values in col A below. 12 months = 52 weeks, 90 days and 3 months = 13 weeks, 24 Months = 104 weeks, 4 months = 17 weeks, 36 months = 156 weeks. Let me know if you need more info thanks once again for your help Frank Ajay |
#2
|
|||
|
|||
Hi
could you email an example sheet -- Regards Frank Kabel Frankfurt, Germany "Ajay" schrieb im Newsbeitrag ... Problem with IF and Nested IF Morning Frank, Not entirely sure what your after Frank; If one looks at Column A below I want to convert them all into weeks format to standardise the data from the different sources. Eg 6 Months and 182 Days (Col A) will become 26 Weeks, 28 Days will become 4 weeks follow this format for all the values in col A below. 12 months = 52 weeks, 90 days and 3 months = 13 weeks, 24 Months = 104 weeks, 4 months = 17 weeks, 36 months = 156 weeks. Let me know if you need more info thanks once again for your help Frank Ajay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message Appearing | Excel Discussion (Misc queries) | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) |