Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2022, 08:57 PM
john_charves john_charves is offline what is formulas for counting value after max digit Windows 11 what is formulas for counting value after max digit Office 2019
Novice
what is formulas for counting value after max digit
 
Join Date: Nov 2022
Posts: 1
john_charves is on a distinguished road
Exclamation what is formulas for counting value after max digit


I have data for water indicator, what is the formula for make 001-999 counted as 2 not -998 (assume max digit is three)?
Reply With Quote
  #2  
Old 11-24-2022, 11:39 PM
ArviLaanemets ArviLaanemets is offline what is formulas for counting value after max digit Windows 8 what is formulas for counting value after max digit Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Quote:
Originally Posted by john_charves View Post
I have data for water indicator, what is the formula for make 001-999 counted as 2 not -998 (assume max digit is three)?

Do you have in some cell a formula like:
Code:
=A2-B2
, where A2 has value 1 and B2 has value 999 (and cell A2 is simply a number formatted with leading zeroes, with real value being 1 - because in case it were text "001", you'd get -999 instead of -998)? Or do you have something entirely different?

When it is a formula described above, then:
Question1: Why B2=999 as border value? Why not 1000? With this rule, there will never be result <-997 when A2=1 - is this OK?
Question2: When B2<999, must be result always be the difference calculated, i.e. 1-998 =-997, or 2-998=-996 (i.e. with A=2 the result will never be <-996), or 2-995=-993? Will 3-998=-995 be right answer? And does this mean, with A2=3, the result can never be less than -995?
Question3: What must be result, when A2=3, and B2=999? The result can't be 4!
Reply With Quote
  #3  
Old 11-25-2022, 01:19 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline what is formulas for counting value after max digit Windows 10 what is formulas for counting value after max digit Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
post a small sample sheet please ( no pics). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Tags
excel 2019, formulas

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
what is formulas for counting value after max digit Trying to change the last digit in a column of 10 digit entries arkansawyer16 Excel 10 04-06-2020 02:03 PM
long digit error Midasbelize Excel 1 05-16-2017 10:14 AM
Regex/wildcard search for dates with 2-digit and 4-digit years Marrick13 Word VBA 2 01-29-2016 07:04 AM
what is formulas for counting value after max digit A challenging digit by digit manipulation, rotate the digit in range of 0 to 9 laucn Excel Programming 14 05-17-2015 12:12 PM
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook JaxV Excel 9 11-14-2014 12:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 AM.


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