If statement with multiple criteria

I am trying to write a formula to check 2 cells, which will have "Y" or "N" in them
The logic is as follows:
IF(Criteria A = TRUE), ((Price-Fees)-Postage)
else
IF(Criteria B = True), (Price-Fees)
else
IF(Criteria C = TRUE), ("")

Criteria A
Sold = "Y"
Post = "Y"

Criteria B
Sold = "Y"
Post = "N"

Criteria C
Sold = "N"
Post = "N"

I hope that makes sense!

usage: calcPostage( SOLD, POST,PRICE,FEE,POSTAGE)

I assumed each was in a cell...
=calcpostage(B2,C2,D2,E2, F2)

Please Login or Register  to view this content.

Hello and welcome to the forum. Below is a formula solution.

Assuming that the Sold value is in A2, the Post value is in B2, Price is in C2, Fees are in D2, and Postage is in E2, try this:

=IF(A2&B2="YY",C2-D2-E2,IF(A2&B2="YN",C2-D2,IF(A2&B2="NN","","")))

Thanks! The VB script works a treat!