You're welcome - thanks for feeding back.

Pete

On Jan 18, 4:55*pm, wrote:
On 18 Jan, 11:44, Pete_UK wrote:





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!- Hide quoted text -

- Show quoted text -

This is exactly what I was looking for--thanks so much for your help.- Hide quoted text -

- Show quoted text -