LinkBack URL
About LinkBacks
I would like to update Cell A1's value using a formula in Cell B1
Cell A1 has a formula in it as follows:
=If(X>N,X-N,N-X)
So I want Cell B1 to:
=if(A1<N,A1=0,0)
Is this possible?
Updating Cell Values Using Formulas in Other Cells
I would like to update Cell A1's value using a formula in Cell B1
Cell A1 has a formula in it as follows:
=If(X>N,X-N,N-X)
So I want Cell B1 to:
=if(A1<N,A1=0,0)
Is this possible?
In short, no - to alter A1's result modify your formula in A1, ie:
=IF(ABS(X-N)<N,0,ABS(X-N))
(the use of ABS removes your existing IF requirement)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks