Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
@IF Function In 123
I'm using 123 bundled in Smart Suite 97.I am trying to use a number returned by "@IF F4=3;1.73;1" contained in cell L4 in cell M4 to do a calculation based on a formula +L4*I4. I've tried numerous other @ functions also and can't seem to get anything besides "ERR" or...- Incubus3
- Thread
- Replies: 1
- Forum: Office suites general discussion
-
@IF Function
In Cell M4 I entered "@IF(F4=3,"1.73","1"), M4 displays 1.73 or 1 depending on the number entered in cell M4,this works fine. How can I take the 1.73 or 1 displayed in M4 to use it in another formula.Any help would be greatly appreciated.I am working in Lotus 123. Thank You.- Incubus3
- Thread
- Replies: 0
- Forum: Data Management Tools general discussion
