G Guest Mar 2, 2004 #1 Is there a function that if I wright text in one box, there is an automatic addition of a number in another box?
Is there a function that if I wright text in one box, there is an automatic addition of a number in another box?
A Andy B Mar 2, 2004 #2 Peter. Yes, probably. We'd need some more information, though, to offer you help on which function to use and how. Andy. Peter said: Is there a function that if I wright text in one box, there is an Click to expand... automatic addition of a number in another box?
Peter. Yes, probably. We'd need some more information, though, to offer you help on which function to use and how. Andy. Peter said: Is there a function that if I wright text in one box, there is an Click to expand... automatic addition of a number in another box?
D Don Guillett Mar 2, 2004 #3 in cell a2 =if(a1="mytext",2,"") -- Don Guillett SalesAid Software (e-mail address removed) Peter said: Is there a function that if I wright text in one box, there is an Click to expand... automatic addition of a number in another box?
in cell a2 =if(a1="mytext",2,"") -- Don Guillett SalesAid Software (e-mail address removed) Peter said: Is there a function that if I wright text in one box, there is an Click to expand... automatic addition of a number in another box?
