I am trying to manipulate an expense statement. I have 4 columns. In column 1 I enter the amt spent for breakfast; column 2 is lunch, column 3 is dinner. In column 4 I want a formula that encompasses several if statements "if column 1 is greater than zero, add $6" "if column 2 is greater than zero, add $10" "if column 3 is greater than zero add $18" the $6, $10, and $18 are per diems allowed by our Client. I then want the formula to total what the per diem should be. for example: let's say column 1 is blank and column 2 and 3 have data ... the result in column 4 should be $28