Formula for multiple criterias and multiple results - IF and AND?

[graphitemonotones]

Hi

I am trying to set up an IF and AND function formula, but am getting confused trying to sort this out by myself.

I have a column (Column A) that will indicate either "W" or "B".
Then I have another column (Column B) that is manually input with a number, or the text "ND".

If Column A is "W" and Column B is "ND", then result in Column C should be ND.
If Column A is "B" and Column B is "ND", then result in Column C should be ND.
But...
If Column A is "W" and Column B is a number e.g. 3.3, then result in Column C should be calculated with a formula (Formula A).
If Column A is "B" and Column B is a number e.g. 3.3, then result in Column C should be calculated with another formula (Formula B).

Can someone advise how I can set this for cells in Column C?

Thank you.

[AliGW]

Maybe this?

=IF(AND(OR(A1="W",A1="B"),B1="ND"),"ND",IF(A1="W",formulaA,formulaB))

Obviously you need to put the formulae in.

These things are much easier to help with if you provide a sample workbook.

[graphitemonotones]

Hi

Thank you, that helped.
Apologies I wasn't able to post a sample file due to restrictions on the laptop I was using to ask the question then.