You’re offline. This is a read only version of the page.
Announcements
Hello.
I'm mining some simple data from daily received excel table and I want to provide them into another one.
Every column is a new day (I managed to get the date, and the variables 'Total' and 'InTime').
I want to put on next row in current column following formula =(InTime/Total).
If I use the formula with numbers (ieg =(10/5)), it gives me a correct result.
But When I want to use variables, I get error with failed write into excel.
See the wanted result bellow:
Because the data will go into visual grapf, I cannot put manually formula into row =(3:3/2:2) - because it gives me error "division by zero" (and I don't want to start a black hole obviously) and this message is on every cell in a row. So I want to make it clean and create it with every new record.
Could anybody help?
Share
Report
All responses (
Answers (
525
