Multiple conditions and IF Statements

[jesoldano]

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'!
B3>10,"Yellow","Green")

Thanks!

 

[Pete_UK]

Try it this way:

=IF('Small Business Card Data'!C3-'Small Business Card Data'!
B3>30,"Red",IF('Small Business Card Data'!C3-'Small Business Card
Data'!B3>10,"Yellow","Green"))

Hope this helps.

Pete

 

[jesoldano]

Try it this way:

=IF('Small Business Card Data'!C3-'Small Business Card Data'!
B3>30,"Red",IF('Small Business Card Data'!C3-'Small Business Card
Data'!B3>10,"Yellow","Green"))

Hope this helps.

Pete






- Show quoted text -

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

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

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

- Show quoted text -