How can you base calculation on 2 conditions?

[surfer]

I am able to write an "If" calculation with one condition and a default result, but cannot figure out how to write an "If" calculation that should only be completed when two conditions are met.

For example, if Color=Blue and Size=Large, then Fish=Marlin

Any help would be appreciated. Thank you...

[ESpringer]

You basically have already written your calculation!

Define the "fish" field as:

If (Color="Blue" and Size="Large";"Marlin";"??")

of course you probably don't want "??" in the event the criteria don't add up... You probably would prefer at least a "Case" function:

Case(Color="blue" and Size="large";"Marlin";

[surfer]

Thank you!

I tried it and it worked. I truly appreciate your help!