July 1, 200421 yr 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...
July 1, 200421 yr 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";
Create an account or sign in to comment