spread sheet formula help

[Rikwaller]

Hello,

Can anyone help me ??

I am using a spreadshhet and wish to include a formula that links one sell to another cell if the value in the cell is less than 60, if it is more than 60 then I want it to link to another cell i.e

someting along the line so of " if A1 = less than 60 then use cell A2, if A1 = more than 60 then use A1"

I am using Lotus 123 ( no choice, work computer. ) If someone could help, I would mucho appreciate it.

Thanks

Simon

 

[marc_howarth]

i'm guessing it'll look something like

IF(A1<60,"=A2", IF(A2>60,"=A1",""))

might want to think about a value for when A1 = 60 though