Support Board

Date/Time: Sun, 08 Sep 2024 00:34:07 +0000

Post From: spread sheet alert formula

[2023-11-20 07:44:21] Link To Thread - Link To Post [Go To First Post]
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