Hi
Can anyone tell me how to enter more than one function on the same selection in Excel? Also to clear the status box to allow multiple bets to enter the market.
Thanks
Multiple functions on one selection with excel?
Anything is possible in Excel but it just requires a bit of effort. There are quite a few examples in the spreadsheet section.
If you want to apply multiple conditions to a cell you can nest if statements, or better, construct a truth table on a seperate spreadsheet to pull a yes or no condition back to your cell.
There is no, quick suggestion or way of doing either, it will involve a bit of work.
If you want to apply multiple conditions to a cell you can nest if statements, or better, construct a truth table on a seperate spreadsheet to pull a yes or no condition back to your cell.
There is no, quick suggestion or way of doing either, it will involve a bit of work.
Thankyou. I don't mind investing the effort if something is doable. Can you link several cells in the new spreadsheet to the instruction cell for example? The status cell won't accept a function, I can clear it manually, but thats not much use for automation