vendredi 3 avril 2020

Adding OR to the middle of google if and formula?

I am trying to add an or function to a formula that works. I need to only edit one small part of the last 2 sections.

=0.2+if(and(O4>0,N4>1),0.3)+if(and(O4>0,N4>1,(T4*24)>19,(S4*24)>7,K4>2),0.3)+if(and(O4>0,N4>1,(U4*24)>29,(T4*24)>29,(S4*24)>7,K4>3),0.1)+if(and(O4>0,N4>1,(U4*24)>39,(T4*24)>39,(S4*24)>7,K4>4),0.1)+if(and(O4>0,N4>1,(U4*24)>49,(T4*24)>49,(S4*24)>9,**K4>4,I4>4**),0.05)+if(and(O4>0,N4>1,(U4*24)>49,(T4*24)>49,(S4*24)>9,**K4>4,I4>4**),0.05)

I need the formula to be if K4 and I4 are above 4 OR R4 is above 10 then continue I have to add the Or R4 part to the furmula. but I cant figure out how to put the or in the middle of the formula.

Here is my sheet: ​https://docs.google.com/spreadsheets/d/1D-J-z-RM9Q9tiI4Fy-Dzyu-hb4Mpft65ARgC2PVmUYI/edit?usp=sharing

Aucun commentaire:

Enregistrer un commentaire