|
|
#1
05-11-2022, 02:37 AM
|
|||
|
|||
Understanding an Excel formula
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 Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Understanding Asterisk in IF functions
|
pcrjyh12 | Excel | 3 | 12-01-2016 07:54 AM |
|
Understanding SmartArt
|
muna | Word | 1 | 10-27-2015 06:39 PM |
|
Understanding Document Corruption
|
Lagrange | Word | 3 | 08-03-2015 11:06 AM |
|
Not understanding discrepancies in homework and need help
|
toasty | Project | 1 | 07-21-2015 01:06 PM |
| need help understanding mailmerge code | lhuffst | Mail Merge | 1 | 02-13-2013 05:19 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode