IF formula

[Shana L]

Sometimes, I figure Excel formulas out, and other times I am clueless. I have done this before with no problem, but today I can not get it.

I need a formula that will reference a cell on Sheet 1 and provide a dollar amount on Sheet 2. I have tried several variations of the formula below:
=IF('Sheet 1'!E52:F52="10","$1,433",IF('Sheet 1'!E52:F52="9","$1,299",IF('Sheet 1'!E52:F52="8","$1,155")))

Any input is welcome and thank you in advance for your assistance.

Shana

[Melvosh]

If E52:F52 are merged as one cell, you can just check against E52, rather than E52:F52. If you are checking against both, you will have to enter the formula as an array formula using ctrl+shift+enter. Be warned that this will only check against and return results based on column E. If you want to return results based on both values, the formula will need to be a bit more complex. You will likely want to remove the quotes around 10, 9 and 8, as the formula will just return FALSE if you're trying to compare numbers to text.

Hope this helps!

[Shana L]

Brilliant Melvosh! Thank you so much. I had tried without the "" around the number, but it was the merge cell that messing things up. Removing the quotes and only referring to E52 did the trick.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.