Support Board
Date/Time: Wed, 27 Nov 2024 04:59:13 +0000
Post From: Column K Status Changes and Accuracy
| [2023-09-13 21:24:08] |
| User772499 - Posts: 48 |
|
I'm using that calculated P/L (cell H41) to determine trade quantity. Basically if the P/L is between A and B trade 1, if it's between C and D trade 2, etc. So in cell J26 for Qty where I have the formula, I get #ARGS! If I override the H41 formula and type in a small number, the J26 formula shows the correct qty. If I use a larger number I get the #ARGS! I put all the formulas on a regular spreadsheet to test it out and it works fine for any number in H41. Is this a number format issue or some other issue? Thanks! |