Formula in a sheet

[gators]

I have these values in the columns
F2 = 336
A2 = 415
B2 = LAST

When i use the formula in cell E2 I have to enter at the end to populate the values . If i change a cell value , for instance B2 = First, the column doesnt change until i enter. Plus I have 2000 rows and cannot drag down the formula like i have done in the past. The format is text and i changed it genereal in E2

= IF(F2<>"",CONCATENATE(F2,"/", A2,"-", B2),A2)

Thanks for any help

 

[stanleydgromjr]

Try this with your spreadsheet open:

Click on (menu):
Tools
Options...
Calculations tab
Calculation, click on 'Automatic', and click on 'OK'


Have a great day,
Stan