Support Board
Date/Time: Sun, 08 Sep 2024 00:34:07 +0000
Post From: spread sheet alert formula
[2023-11-20 07:44:21] |
User928353 - Posts: 8 |
hi i have tried every possible combination but i keep getting syntax error for formula i am developing here what i want if the value in ID4.SG1 has 5 character like 12345 and the value in ID4.SG2 has 4 character number like 1234 it then Triger buy as it has more number in it, dosent just have to be greater but has to be greater then by a extra numerical number as compared to the other number , i came up with this but it still give me error can you help please =IF(LEN(MID(ID4.SG1, 3, 100)) > LEN(MID(ID4.SG2, 3, 100)) . Thank You |