Support Board
Date/Time: Tue, 26 Nov 2024 15:43:01 +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 |