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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

@IF Function

Status
Not open for further replies.
Incubus3

Incubus3

Technical User
Jan 7, 2000
2
US
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.
 
Status
Not open for further replies.

Similar threads

yimitz
  • Locked
  • Question
InstRev function in SQL for HIR
Replies
0
Views
293
yimitz
yimitz
sa0309
  • Locked
  • Question
to_date function
Replies
2
Views
342
rasETL
rasETL
srvu
  • Locked
  • Question
How to populate Foreign key column if it is not identity
Replies
4
Views
173
srvu
srvu
jdkCannon1
  • Locked
  • Question
Functions and SP inside packages
Replies
4
Views
230
jdkCannon1
jdkCannon1
MsSamson
  • Locked
  • Question
Transform If-then-else
Replies
2
Views
141
MsSamson
MsSamson

Part and Inventory Search

Sponsor

Back
Top