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 ...
Logic statements in Microsoft Excel allow you to test the contents of cells to see if they meet your criteria. For example, if a spreadsheet lists sales figures, you can use Excel logic statements to ...
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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback