=IF(J2="NA",I2,K2) is in L2 on the sheet and returns the correct data in L2. When you copy the statement down the rows change you would expect but the function returns the I2 data for every row in L2, L3, L4, ETC.
=IF(J2="NA",I2,K2) is in L2 on the sheet and returns the correct data in L2. When you copy the statement down the rows change you would expect but the function returns the I2 data for every row in L2, L3, L4, ETC.
It sounds like Calculation in Excel is set to Manual.
Try this:
From the Excel Main Menu:
<tools><options><calculation>
...Check: Automatic
Does that help?
It was in fact set to Manual.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks