I know how to use an IF statement to return a value from a cell B if cell A
is true (for example =IF(A1=100,B3,"no value found"). However i need to
compare 2 values and return a 3rd if both values are true. For example, If
cell A is 100 and cell B is <200 then return cell c.