Hello,
Anybody know:
why on the Bet Angel Template the excel file will not recognise some of the formulas that seem to work in other fields. See Attachment.
I tried to drag and drop down the file to replicate the formulas but that didn’t work, and it has seemed to wreck any hopes of entering working formulas into those affected fields. I've tried reformatting but it doesn’t seem to help.
Any ideas why? Is it not possible to Copy and Paste these formulas as if I want to create a sheet coveing every race this is going to take a long - long time.
Bet Angel Template issue
I dont quite understand your problem as described, but if your problem is that you can see the formula rather than the result then you can toggle that with Ctrl + Tilde Keyxtrader16 wrote: ↑Fri Jul 30, 2021 10:05 amHello,
Anybody know:
why on the Bet Angel Template the excel file will not recognise some of the formulas that seem to work in other fields. See Attachment.
I tried to drag and drop down the file to replicate the formulas but that didn’t work, and it has seemed to wreck any hopes of entering working formulas into those affected fields. I've tried reformatting but it doesn’t seem to help.
Any ideas why? Is it not possible to Copy and Paste these formulas as if I want to create a sheet coveing every race this is going to take a long - long time.
Excel sometimes with the templates will think that it's text rather than a formula
If you change the formatting of it to general (or number if it's going to be a number), click into the formula bar at the end of the formula and press enter, should resolve it
Once you've done it you should just be able to copy the formula down
If you change the formatting of it to general (or number if it's going to be a number), click into the formula bar at the end of the formula and press enter, should resolve it
Once you've done it you should just be able to copy the formula down