Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 12 May 2024 14:01:12 +0000
Post From: Lock a One Time Value in a spreadsheet
| [2014-02-07 06:28:39] |
| vegasfoster - Posts: 444 |
|
Just add another condition that the previous cell has to be 0, =IF(and(F3>5000, O4=0), A3-INT(A3),O4)
|