What are you trying to achieve?
Trying to fix a bug where I am subtracting 1 from a cell in a google spread sheet
Steps taken so far
Searched the make community for similar errors and tried the suggested solutions.
Trying to fix a bug where I am subtracting 1 from a cell in a google spread sheet
Searched the make community for similar errors and tried the suggested solutions.
Hi @Anne_Pelgrims , Welcome to the community, if I may ask what’s an example value of the Bulk (I) variable, is it a valid cell value like A1, A2 etc…?
It contains the value 100 at the moment and I want to subtract 1 from it
In this example it would be in cell I2
The Cell ID variable has to be a valid value like I2, if you subtract 1 from Bulk (I) that would result to 99, which isn’t a valid cell ID value, hence the error, In place of the Value calculations like Bulk (I) -1 is still valid, but not for the Cell ID.
Thank you so much…I will make the change and test it out later tonight.
I appreciate your assistance.
I tried what you suggested and got the same error. I think the problem is actually how I am using the spreadsheet. Ie. Cell I2 contains the value of 100. I want to subtract 1 from 100 and replace the value in the cell with 99 and so on.
It’s a really simple task but I can’t make it work.
TIA, Anne