Hi is there any way to make a forumala only calculate once.
Cell A1 is updated via live data every 2 minutes.
If cell A1 is between numbers 1 and 5 i would like the value of C1 to be entered into B1
I have in B1 the formula =IF(AND(A1>=1,A1<=5),C1,0)
Hope someone can help.
Bookmarks