Use a formula with 2 arguments

[Steved]

Hello from Steved

1st argument = $25000
2nd Argument = Sum: $24000

My Attempt =sum ($25000-Sum: $24000)

I'm tyred off deleting sum: for the above to work

$25000
$24000
$-1000

Please is their away of doing the above

Thankyou

 

[Fred Smith]

Your post is very confusing. Show us the formula you are using. If you
simply want to subtract 24000 from 25000, use:
=25000-24000

Regards,
Fred

 

[Steved]

Hello Fred from Steved

=sum ($25000-Sum: $24000)

to Leave -$1,000

 

[Steved]

Hello from Steve Dee

I'm in another world

I was not thinking please ignore

=sum($25000-$24000) works perfectly

I saw "Sum:" hence =sum($25000-sum: $24000)

So Inputted what I saw. "half a sleep"

Thankyou.

 

[Teethless mama]

=sum($25000-$24000) works perfectly

Why you need Sum? why not just $25000-$24000

 

[Steved]

Hello Teethless mama from Steved

Simply put I expect everyone to understand my "stupidity"

What I meant to do was

In The Col E:E I have "Sum: $25000"
In The Col I:I I have "$24000"

ok Let me start again and this time hopefully I know what I'm Talking about

Can I use a Formula to Subtract Col E:E from Col I:I, as at the moment I've
got to Highlite "Sum: " then delete, hopefully I can avoid the Delete please.

Thankyou.

 

[David Biddulph]

If both entries are text
=RIGHT(I1,LEN(I1)-1)-RIGHT(E1,LEN(E1)-6)

If column I is a number formatted as currency
=I1-RIGHT(E1,LEN(E1)-6)

 

[Steved]

Hello David

Thankyou very much

Excellent Value

Steved