Conditioning formula to convert "x" into another cells value
Closed
blondelakelover
Posts
1
Registration date
Wednesday January 27, 2016
Status
Member
Last seen
January 27, 2016
-
Jan 27, 2016 at 12:24 PM
Blocked Profile - Jan 27, 2016 at 05:05 PM
Blocked Profile - Jan 27, 2016 at 05:05 PM
Related:
- Conditioning formula to convert "x" into another cells value
- Convert m3u to mp3 - Guide
- Convert picture to shape powerpoint - Guide
- How to convert number into words in ms word in shortcut key - Guide
- Excel formula to convert number to words - Guide
- Convert dts to ac3 mkvtoolnix - Guide
1 response
OK, the syntax for if is as follows:
=IF(LOGIC_TEST,true,false)
=If(a3<>"",a2,"")
The above would populate the cell that has this formula with A2, as long as something is in A3. It shows nothing if there is nothing.
Give that a shot and see if it is acting how you would expect. Then use that example and continue to cascade the solution!
I have said it once, I will say it again. IT!
=IF(LOGIC_TEST,true,false)
=If(a3<>"",a2,"")
The above would populate the cell that has this formula with A2, as long as something is in A3. It shows nothing if there is nothing.
Give that a shot and see if it is acting how you would expect. Then use that example and continue to cascade the solution!
I have said it once, I will say it again. IT!