#1




what is formulas for counting value after max digit
I have data for water indicator, what is the formula for make 001999 counted as 2 not 998 (assume max digit is three)?

#2




Quote:
Do you have in some cell a formula like: Code:
=A2B2 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. 1998 =997, or 2998=996 (i.e. with A=2 the result will never be <996), or 2995=993? Will 3998=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! 
#3




Hi
post a small sample sheet please ( no pics). Thx
__________________
Using O365 v2407  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 
Tags 
excel 2019, formulas 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Trying to change the last digit in a column of 10 digit entries  arkansawyer16  Excel  10  04062020 02:03 PM 
long digit error  Midasbelize  Excel  1  05162017 10:14 AM 
Regex/wildcard search for dates with 2digit and 4digit years  Marrick13  Word VBA  2  01292016 07:04 AM 
A challenging digit by digit manipulation, rotate the digit in range of 0 to 9  laucn  Excel Programming  14  05172015 12:12 PM 
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook  JaxV  Excel  9  11142014 12:25 AM 