if or statement

[OceanPlanet13X]

If or statement ?

I cannot make the formula below work, if column A is equal to 5 then return the value 180, if column A is nil , look at column C if equal to 7 return 370 or nil value

Col A Col B Col C Col D
Run 1 Run 2 Total Run
5 4 9
4 6 10

=if(and((A22>=5,180,if(C22>=7,370,0)

Thanks in advance for the help

 

[JoeMo]

=if(A22>=5,180,if(C22>=7,370,0))

 

[OceanPlanet13X]

thank for quick reply - it works