Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-11-2022, 02:37 AM
Joanne Joanne is offline Understanding an Excel formula Windows 7 32bit Understanding an Excel formula Office 2010 32bit
Advanced Beginner
Understanding an Excel formula
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Understanding an Excel formula Understanding Asterisk in IF functions pcrjyh12 Excel 3 12-01-2016 07:54 AM
Understanding an Excel formula Understanding SmartArt muna Word 1 10-27-2015 06:39 PM
Understanding an Excel formula Understanding Document Corruption Lagrange Word 3 08-03-2015 11:06 AM
Understanding an Excel formula 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft