![]() |
#1
|
|||
|
|||
![]()
Good morning
I have been given a spreadsheet and, while I can see what the formula does, I don't understand how it is working. Can somebody please explain, step by step? =(IF(C139=0,,C139&" ")&IF(J139=0,,J139&" ")&IF(K139=0,,K139&" ")&IF(L139=0,,IF(L139=M139,,L139&" "))&IF(M139=0,,M139&" ")&IF(N139=0,,N139)) C = Name of store J = Address1 K = Address2 L = Town M = County N = Post code Many thanks |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
pcrjyh12 | Excel | 3 | 12-01-2016 07:54 AM |
![]() |
muna | Word | 1 | 10-27-2015 06:39 PM |
![]() |
Lagrange | Word | 3 | 08-03-2015 11:06 AM |
![]() |
toasty | Project | 1 | 07-21-2015 01:06 PM |
need help understanding mailmerge code | lhuffst | Mail Merge | 1 | 02-13-2013 05:19 PM |