Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2020, 09:33 AM
kingston123 kingston123 is offline What's wrong with formulae? Windows 10 What's wrong with formulae? Office 2013
Advanced Beginner
What's wrong with formulae?
 
Join Date: Sep 2018
Posts: 75
kingston123 is on a distinguished road
Default What's wrong with formulae?

=IF(B2="",A1,N(A1)+1)



Why it is showing 66 so many times instead of once?
Reply With Quote
  #2  
Old 06-28-2020, 09:54 AM
Purfleet Purfleet is offline What's wrong with formulae? Windows 10 What's wrong with formulae? Office 2019
Advanced Beginner
 
Join Date: Jun 2020
Posts: 39
Purfleet is on a distinguished road
Default

please add attachements so that we dont have to recreate the data and guess what you have in certain colunmns
Reply With Quote
  #3  
Old 06-28-2020, 10:29 PM
ArviLaanemets ArviLaanemets is offline What's wrong with formulae? Windows 8 What's wrong with formulae? Office 2016
Expert
 
Join Date: May 2017
Posts: 572
ArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really niceArviLaanemets is just really nice
Default

Attaching the file will take off several days from you getting right answer probably, but on wild guess from 2 mm I can see about column B, it looks like cells B82:B88 are merged.
Reply With Quote
  #4  
Old 06-29-2020, 12:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline What's wrong with formulae? Windows 7 64bit What's wrong with formulae? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,416
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

Merged cells in col B.....
Reply With Quote
  #5  
Old 06-29-2020, 10:07 AM
kingston123 kingston123 is offline What's wrong with formulae? Windows 10 What's wrong with formulae? Office 2013
Advanced Beginner
What's wrong with formulae?
 
Join Date: Sep 2018
Posts: 75
kingston123 is on a distinguished road
Default

I attached my file with B merged cells.
Attached Files
File Type: xlsm PERSONAL.xlsm (14.7 KB, 2 views)
Reply With Quote
  #6  
Old 06-29-2020, 10:55 AM
Purfleet Purfleet is offline What's wrong with formulae? Windows 10 What's wrong with formulae? Office 2019
Advanced Beginner
 
Join Date: Jun 2020
Posts: 39
Purfleet is on a distinguished road
Default

merged cells are again the problem. Everyone on this board is saying the same thing - dont use them.

as a test in your file go to cell c1 and type =b1, this will show you want excel 'sees' (0 is am emtpy cell) so at row 21, excel can see that it contiains the merged data and therefore adds 1 to the number above, 22 is empty so it repeats the number above

Last edited by Purfleet; 06-29-2020 at 10:56 AM. Reason: typo
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with formulae Zoemoe Excel 3 07-02-2017 05:40 PM
How can I create multiple Formulae Easily Chris Waller Excel Programming 0 09-01-2016 12:25 PM
What's wrong with formulae? formulae to combine excel records H28Sailor Excel 7 03-31-2013 02:26 PM
What's wrong with formulae? Use NUMPAGES in formulae Friedebarth Word 1 11-30-2011 02:22 PM
Why wont my simple formulae work? Florish Excel 4 02-17-2009 07:33 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:38 PM.


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