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.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.