Login Page - Create Account

Support Board


Date/Time: Tue, 04 Mar 2025 21:23:00 +0000



Post From: Spreadsheet CELL not updating as expected + steps to reproduce.

[2021-12-24 01:27:47]
User346098 - Posts: 47
IT seems to be working now, I don't understand why, I didn't do any different, only difference market is closed now that I can think of...

[ IF ] IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEE... = "BANANAS" (text)
  [ = ] VLOOKUP("DEAD", DM3:DM600,1) = "DEAD" = 0 (number, integer)
    [ VLOOKUP ] VLOOKUP("DEAD", DM3:DM600,1) = #N/A (error)
      [ "DEAD" ] "DEAD" = "DEAD" (text)
      [ DM3:DM600 ] DM3:DM600 = DM3:DM600 (range)
      [ 1 ] 1 = 1 (number, integer)
    [ "DEAD" ] "DEAD" = "DEAD" (text)
  [ "CHEESE" ] "CHEESE" = (not evaluated)
  [ "BANANAS" ] "BANANAS" = "BANANAS" (text)


spreadsheet system trading study on chart but the sheet in this spreadsheet I am testing isn't associated with any chart if it matters...