Use a formula with 2 arguments

  • Thread starter Thread starter Steved
  • Start date Start date
S

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
 
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
 
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.
 
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.
 
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)
 
Back
Top