IF AND OR Statement with 4 variables

[Webbers]

I am stuck on an IF formula using AND/OR with 4 criteria. I attempted to adapt a much smaller version of this formula, and it is not working. This is what I have:

=IF(OR(AND($H$7="Y",$H$5>=1),AND($H$7="Y",$H$5="-"),AND($H$7="N",$H$5="-"),AND($H$7="N",$H$5>=1)),37.5,29,20.5,29)

Cell H7 will contain either "Y" or "N"
Cell H5 will contain a dollar amount or "-" (dollar amount if financed, and "-" is a cash sale)

This formula is supposed to calculate the recording fees based on the following information:

H7 - Y, H5 - more than $1 = $37.50
H7 - Y, H5 - "-" = $29.00
H7 - N, H5 - More than $1 = $20.50
H7 - N, H5 - "-" = $29.00

Can someone help me to understand what I am doing wrong? Thanks in advance for all you help. As always it is greatly appreciated!

[NBVC]

Try:

=IF(H5="-",29,IF(H7="Y",37.5,20.5))

[formulaic]

You really cleaned that up!

[Webbers]

NBVC----

Nope that does not work right for all the variables.

[NBVC]

When does it not work?

[Webbers]

when the desired result is $29.00 it does not work properly.


CORRECT H7 - Y, H5 - more than $1 = $37.50
Displays $37.50 H7 - Y, H5 - "-" = $29.00
CORRECT H7 - N, H5 - More than $1 = $20.50
Displays $20.50 H7 - N, H5 - "-" = $29.00

[NBVC]

Maybe it's not a dash, and it's a 0 formatting as Accounting?

Try:


=IF(H5=0,29,IF(H7="Y",37.5,20.5))

[Webbers]

NBVC, that was it! It works perfectly! Thanks so much!