Hello,
I Hope someone will be able to help me.
I need column x to return a blank if column y has a value.
Here is the existing formula I have currently in column X
=IF(OR(ISBLANK(Formulas!A$17),ISBLANK(K5)), "", Formulas!A$17-K5)
Here is a screen shot. As you can see both column x and y have a value but I need column X to be blank if Column Y has a value.
Capture.JPG
Bookmarks