Hello,
I have been working on a simple formula to evaluate two cell to provide the results if the cell does not equal X.
Got that one worked out, still want that but if the cell is empty I want the cell to be blank.
Book1.xlsx
Hello,
I have been working on a simple formula to evaluate two cell to provide the results if the cell does not equal X.
Got that one worked out, still want that but if the cell is empty I want the cell to be blank.
Book1.xlsx
What exactly is that formula supposed to be doing?
If you want to exclude if the cell is blank, just use =if(A1="","",your-formula)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
may be non array
=IF(OR(A1="",B1=""),"",SUMPRODUCT((A1:B1<>"X")*1)*(Range you want to sum))
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
When the cells is blank it still returns the value of 2, I want the array result to be blank when the cell are empty.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks