I have a spreadsheet with multiple formulas. I want a final column to give me a yes or no base on one columns numbers being greater than 0 and the second columns numbers being less than 2000.
Cheers
Cheers
-
Say Column A needs to be greater than 0 and Column B < 2000.
Place this in the column you want it to appear in:
=if(and(Ax > 0,Bx<2000),"YES","") {where x is the row number }
Place this in the column you want it to appear in:
=if(and(Ax > 0,Bx<2000),"YES","") {where x is the row number }
-
use if function