“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I need to filter the F4 help values in Excel .

Solved by K. S. in 18 mins

Hi, I'm trying to use the IF-AND formula to return an value from two cells in excel but can't get it to work so could someone take a look and advise please? So far I have got - =IF((AND (E4 =2,F4<0.6),45, IF((AND (E4 =2,F4>0.6),60, IF((AND (E4 =2,F4>1),85, IF((AND (E4 =1, F4<0.1),12, IF((AND (E4 =1, F4<0.15),15, IF((AND (E4 =1, F4<0.175),18, IF((AND (E4 =1, F4>0.176),24, IF((AND (E4 =Courier, F4<0.1),12, IF((AND (E4 =Courier, F4 <0.15),15, IF((AND (E4 =Courier, F4 <0.175),18, IF((AND (E4 =Courier, F4 >0.176),24))))))))))))))))))))))

Solved by A. L. in 22 mins

=IF(AND(F4>O4,G4<P4),IF(OR(E4>(F4-(F4-G4)*0.25),E4<(G4+(F4-G4)*0.25),"TRUE")) formula help

Solved by X. Q. in 30 mins

This wont work why? =Ifs(F4>100 "Achieved Standard, F4=100 ,"Achieved Standard, F4<100,"Not Achieved Standard)

Solved by D. E. in 29 mins

I have a Table (A1:F4). There are names in A1:A4. There are random values in B1:F4. I need a formula that will search for a value. and return the name in the row that its in & that does not use helper columns

Solved by A. Q. in 28 mins