Easy Question - IF, AND, OR, ERROR

Hi Excel Geniuses,

I'm sure this will be an easy one for you, but I've been struggling with it, so I would really appreciate the help.

We're currently completing our annual salary review & have given suggested increases to all our employees, however the managers have an oppurtunity to propose a different increase if they request & I'm trying to give them the oppurtunity to enter either a proposed increase amount in column C or a proposed increase % in column D (though if they enter a figure into both columns, I want it to error out).

In the NEW SALARY column (F), I therefore need a formula that reads as below;

If Proposed Increase amount (C) AND Proposed Increase % are BOTH NOT BLANK, then error.
AND
If Proposed Increase amount (C) AND Proposed Increase % are BLANK, THEN Current Salary (A) + Suggested Increase Amount (B)
BUT IF Proposed Increase amount (C) is NOT BLANK, THEN Current Salary (A) + Proposed Increase Amount (C)
BUT IF Proposed Increase % (D) is NOT BLANK, THEN Current Salary (A) + (Current Salary (A) * Proposed Increase % (D))

I hope that makes sense, it's not that I want to give either the Proposed Increase amount or Proposed Increase % columns prominence over each other, it's just that I want whichever one is filled out to be used in the calculation.

Workbook attached (I'm sure that would help, I'm not sure my explination above was that clear, sorry... )

Example workbook.xlsx

Hi Willem,

Thank you for this!

I really liked your data validation idea, I've implemented that & I like that alot.

However I'm not sure your If statement has all the conditions I need.

The problem is the Proposed Increase amount column is a currency column & the Proposed Increase % column is a % column. So I think I need an extra piece of formula that will be able to treat them differently..

Thanks newdoverman!

I actually really like the data validation approach that Wilelm has taken, so I'd like to use that idea.

Is there any way you would be able to re-do that formula without the "Error" element, as that is already taken care of. The formula that I would therefore need would look like below;

In the NEW SALARY column (F), I therefore need a formula that reads as below;


If Proposed Increase amount (C) AND Proposed Increase % are BLANK, THEN Current Salary (A) + Suggested Increase Amount (B)
BUT IF Proposed Increase amount (C) is NOT BLANK, THEN Current Salary (A) + Proposed Increase Amount (C)
BUT IF Proposed Increase % (D) is NOT BLANK, THEN Current Salary (A) + (Current Salary (A) * Proposed Increase % (D))

Sorry to be a pain, would you be able to help with that?

Thank you so much! SOLVED!