Excel formula not working in O365 but in desktop

[NikkiMc204]

Hello All

I'm using this formula
=IF($E2<>"",IF(AND($F2<>"",CELL("address")=ADDRESS(ROW($E2),COLUMN($E2))),NOW(),IF(CELL("address")<>ADDRESS(ROW($E2),COLUMN($E2)),F2,NOW())),"")
ctrl+shift+enter

it works perfectly fine in the desktop version of excel but does nothing in office365.

Anyone know why it doesn't work or a possible workaround? or do i need to tell the peeps that i work with to just open in desktop version.

 

[Fluff]

That does work with 365, but only the desktop version, not with the online version. A lot of the CELL arguments do not work online, so they will need to use the desktop.

 

[NikkiMc204]

Ok no worries, thanks for the explanation

 

[Fluff]

You're welcome & thanks for the feedback.