Subtracting in Excel using StudioX

Hi All,

I’m in need of some assistance. I seem to can’t subtract in excel using studiox. I’ve read many post and it seems every single one of them I have tried does not work. Help will be much appreciated.

Here is my current setup.

Here is my data set on excel.

I keep getting the #NAME error. What I’m trying to do is subtract AT - AU to get the sum in AV. Note, this is already under “For each excel row.”

Note, this is in an IF function and it works fine. It’s really the subtraction I’m stuck on.

Many thanks


Since I’m a new user, they only allow me to upload one image at a time. Please find the excel screenshot attached.

Thanks again

DemoStudiox.zip (59.5 KB)
Hello @JohnnyTAK ,

Please find the attached Workflow build using Sudiox. It will help you to solve the Subtraction issue.

Thanks for the feedback. Unfortunately, this did not work. Please see screenshot.
image

Hello,

Did you tried to execute the same workflow which I shared?? It executed in my machine… If it’s working you can use the same logic,

Hi, sorry for the delay in following up. I did try your workflow but it seems to not work. Please find the screenshot of what was applied.

Thanks for your continued help.
image

What’s d error that you are getting?? Can you run in debug mode and check where it’s failing

Here is the result. It’s not an error but it is replicating on what is on each cell but I need it to do the actual formula.

Sorry, I’m not sure how to do this in the debug mode.

Thanks
image

What is the type of the these numbers is it a number or text?? Can you check once manually are you able to subtract 2 cells??

Hi Rahul,

They’re “numbers”. They’re not text or “general”. I believe that’s what you were asking. If I was to do this manually in excel, it would work. Unfortunately, I am looking for StudioX to perform this automation.

Thank you,
Johnny

I asked just to verify. Are you converting something while substracting??

Because in the flow which I shared also, I used studios and I worked fine… Can you print the result in a message box before writing to cell.

No worries. The results are the previous screenshot shared but here is the excel version with the formula included.

This is under an “if” function under “for each excel row”.

It is properly writing the formula as seen above. Although, I need it to calculate rather than write out/read out the calculation.

Can u share the excel which you are using?

Spendbook for Rahul.xlsx (10.2 KB)

I can’t share the actual workbook due to confidential information. Although, I did copy a portion of the workbook and uploaded in a new file.

Please note, line 2-8 was using your formula above. Line 9-10 was using the formula (=AT-AU). For Line 11-16, i used =SUM(AT2)-AU2 but this is limited to only cell 2 (even with for each excel row).

I hope this helps.

Thanks again,
Johnny

@JohnnyTAK Try this expression

CDbl(CurrentRow("AT").ToString)-CDbl(CurrentRow("AU").ToString)

Hi Ushu,

I removed my expression and entered yours into the “text” area.

This is now what I’m viewing as a result.

Sorry, I’m definitely stumped here.

Thank you,
Johnny

@JohnnyTAK Can your workflow please and also excel with sample data

Hi Ushu,

For workflow, it’s on a “for each excel row”. Within it, I’m doing quite a bit of VLOOKUP and other “if” functions. They’re all automating correctly. It’s only the subtraction that’s not occurring.

For results, I refer you to the "spendbook for rahul.xlsx. attached from a previous post. There are context to that post as well.

Please let me know if you can assist.

Thanks,
Johnny

@ushu, still no luck on my end. Any other suggestions.

Thanks!