Try it this way:

=IF('Small Business Card Data'!C3-'Small Business Card Data'!
B330,"Red",IF('Small Business Card Data'!C3-'Small Business Card
Data'!B310,"Yellow","Green"))

Hope this helps.

Pete

On Jan 18, 3:54*pm, wrote:
Hello--I am trying to write an IF statement with more than 2
conditions. *Ultimately, I would like to have a formula that
calculates the following:

IF #1 -- #2 is 10, return "Yellow," Otherwise, return "Green." AND/
OR If #1 -- #2 30, Red, Otherwise return yellow or green (based on
thresholds above). *Is this possible?

This is what I have so far:
=IF('Small Business Card Data'!C3-'Small Business Card Data'!
B310,"Yellow","Green")

Thanks!