Multiple IF statements in the same cell

[kschmit1]

I know there's a lot out there on multiple IF statements but I was not able to find an answer to what I specifically am trying to accomplish here.

In D18, I have a yes/no response. Depending on the contents of this cell I want a value to return in G18.

If Y = $2750
If N = $2160
If blank = $0.00

I can achieve this when just yes and no are involved with this formula =IF(D18="Y",2750,"2160") but I cannot figure out how to yield a result for if D18 is blank to keep G18 also blank. Is conditional formatting my best option for this cell, I know I can change the text to white for anything under $2160.00 but I preferably want $0.00 to display when there is not yet a response in D18.

Any ideas?

[Tony Valko]

Assuming the only possible cell entries are either Y, N or empty/blank:

=IF(D18="","",IF(D18="Y",2750,2160))

[kschmit1]

Thank you worked awesome!

[Tony Valko]

You're welcome. Thanks for the feedback!