Excel is many things: powerful, useful, colorful, handy, but its logic functions can be challenging to newcomers due to their implied logic, and a shorthand syntax designed to fit on a single line in ...
I have a simple formula: =IF(AND(B1="109-1",C1=1),"D1","0") Problem is when the value is true, my cell value becomes "D1" rather than the data in cell D1. How do I force this formula to reference data ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback