Microsoft Office Forums what is formulas for counting value after max digit

#1
11-24-2022, 08:57 PM
 john_charves Windows 11 Office 2019 Novice Join Date: Nov 2022 Posts: 1
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)?
#2
11-24-2022, 11:39 PM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 892

Quote:
 Originally Posted by john_charves 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!
#3
11-25-2022, 01:19 AM
 Pecoflyer Windows 10 Office 2021 Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,831

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 Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post arkansawyer16 Excel 10 04-06-2020 02:03 PM Midasbelize Excel 1 05-16-2017 10:14 AM Marrick13 Word VBA 2 01-29-2016 07:04 AM laucn Excel Programming 14 05-17-2015 12:12 PM JaxV Excel 9 11-14-2014 12:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:56 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top