PING: Excel Gurus

[Dodgerchick]

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



Thanks in advance.

[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.

[HerRealName]

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


edit: or just do what henry suggests . seems like it should work

[JediKooter]

Just type 25 in column F.

[Dodgerchick]

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

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

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]

Glad I could help DC!

[Vince, Pt. II]

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