View Single Post
 
Old 05-11-2022, 02:37 AM
Joanne Joanne is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jul 2013
Posts: 58
Joanne is on a distinguished road
Default 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
Reply With Quote