PING: Excel Gurus

Dodgerchick · 10-14-2020, 01:11 PM

I want to subtract H9-G9, add 1 and remove the letter. Total remits should be 25, not 24:

Thanks in advance.

henry296 · 10-14-2020, 01:22 PM

Assuming the numbers are always 6 digits after the letter.

Right(h9,6)*1 - right(g9,6)*1 +1, should work.

If there is always one letter character, you could use something like this trim(mid(g9,2,100))*1 to convert to a number.

Using the multiply by 1 helps convert it from a string to a number.

HerRealName · 10-14-2020, 01:25 PM

Seems like =right(H9,6)-right(g9,6) + 1 should work.

edit: or just do what henry suggests

. seems like it should work

JediKooter · 10-14-2020, 01:31 PM

Just type 25 in column F.

Dodgerchick · 10-14-2020, 01:39 PM

Quote:

Originally Posted by henry296

Assuming the numbers are always 6 digits after the letter.

Right(h9,6)*1 - right(g9,6)*1 +1, should work.

If there is always one letter character, you could use something like this trim(mid(g9,2,100))*1 to convert to a number.

Using the multiply by 1 helps convert it from a string to a number.

It worked! Thanks, Henry

Quote:

Originally Posted by HerRealName

Seems like =right(H9,6)-right(g9,6) + 1 should work.

edit: or just do what henry suggests

. seems like it should work

Hah! Thanks for chiming in

Quote:

Originally Posted by JediKooter

Just type 25 in column F.

That's too much work, I want excel to do it for me.

Smartypants

JediKooter · 10-14-2020, 01:57 PM

Glad I could help DC!

Vince, Pt. II · 10-14-2020, 02:29 PM

Inquiring minds want to know: why start on row 8?

10-14-2020, 01:22 PM	#2
henry296 College Starter Join Date: Oct 2000 Location: Pittsburgh, PA	Assuming the numbers are always 6 digits after the letter. Right(h9,6)1 - right(g9,6)1 +1, should work. If there is always one letter character, you could use something like this trim(mid(g9,2,100))*1 to convert to a number. Using the multiply by 1 helps convert it from a string to a number. __________________ "It's a great day for hockey" - "Badger" Bob Johnson

10-14-2020, 01:25 PM	#3
HerRealName College Prospect Join Date: Dec 2002	Seems like =right(H9,6)-right(g9,6) + 1 should work. edit: or just do what henry suggests . seems like it should work Last edited by HerRealName : 10-14-2020 at 01:26 PM.

10-14-2020, 01:31 PM	#4
JediKooter Coordinator Join Date: Dec 2004 Location: San Diego via Sausalito via San Jose via San Diego	Just type 25 in column F. __________________ I'm no longer a Chargers fan, they are dead to me Coming this summer to a movie theater near you: The Adventures of Jedikooter: Part 4

10-14-2020, 01:57 PM	#6
JediKooter Coordinator Join Date: Dec 2004 Location: San Diego via Sausalito via San Jose via San Diego	Glad I could help DC! __________________ I'm no longer a Chargers fan, they are dead to me Coming this summer to a movie theater near you: The Adventures of Jedikooter: Part 4

10-14-2020, 02:29 PM	#7
Vince, Pt. II Pro Starter Join Date: Sep 2009 Location: Somewhere More Familiar	Inquiring minds want to know: why start on row 8?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)