I require an IF formula that adds the value from 4 cells and if the value is greater than 16 then I require the value of Cell A1 to appear. if the addition of the 4 cells adds up less than 16 then I require the cell to show 16.
Below is in descriptive terms what I require the formula to do. I just need the correct wording in the formula.
=IF(A1+A2+A3+A4>16, (True "Value of A1") , (False"16"))
Bookmarks