If statement for multi criteria

Dear all

How should i amend the following formula
when i want to say , if the E7 is "adult", "SIC-Adult", "Child","SIC-Child" , then $F7 ( no only "Adult"

=IFERROR(IF($E7="adult",$F7,$F7/H$4),"")

How can i do it ?

Eric

That is a bit confusing! Try listing yoour criteria and results so that they make more sense, something like.

E7="Adult", result =$F7
E7="SIC-Adult" result =$G7
etc..

Please list all possible combinations.

Dear Jason

The selection for user are :

Coach
Adult
Child
SIC-Adult
SIC-Child

They can select all these option

The return should go to F7. If those have been selected, it does not need to be divided by H4.
If user select "Coach"the return should be divided by H4

Hope that is clear

ERic

Mab be.
=IFERROR(IF($E7="adult",$F7,$F7&H$4),"")

Can i upload the file for your view

the formular is in Tab - Calculation

The suggesiton in post 3 looks as if it has already answered your question, but if not then maybe this one.

=F7/IF(E7="Coach",H7,1)

Dear TMS

I tried your formula , it returns the correct number but it does not prompt F7 , instead goes F7/H4
=IFERROR(IF(OR($E7="adult",$E7="SIC-adult",$E7="child",$E7="SIC-child"),$F7,$F7/H$4),""

Anything wrong

Thanks