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

If A is True, or B is True, or C is True, or D is True, then E is False, but if A-D is False then E is True, please help me to create a formula.

Solved by F. A. in 22 mins

I am trying to combine if statements if true then if this or this or this is true (if true) =IF(SEARCH("($",MID(T5,1,O5))>0 (then if either of these are true) IF(SEARCH("CASH",MID(T5,1,O5))>0,1 IF(SEARCH("PYMT",MID(T5,1,O5))>0,1 IF(SEARCH("PAYMENT",MID(T5,1,O5))>0,1

Solved by F. W. in 19 mins

=IF(D1470<E1470,"True",IF(D1470>E1470,"False",IF(E1470=D1470,"True"))) But if E1470 is blank then, how can we show this trueplease help

Solved by S. L. in 22 mins

having problems with the formula below =IF((AND(I12=0,I18=0)),"30%",IF((AND(I12>0,I18=0)),IF(VLOOKUP(H6,Sheet2!A:B,2,TRUE)>30%,"30%",IF((AND(I12=0,I18>0)),IF(VLOOKUP(H6,Sheet2!A:B,2,TRUE)>30%,"30%",IF((AND(I12>0,I18>0)),((VLOOKUP(H6,Sheet2!A:B,2,TRUE))))),(VLOOKUP(H6,Sheet2!A:B,2,TRUE))))))

Solved by O. A. in 27 mins

Hi, i am wondering if i can put a formula (e.g. DATE(), as true value of a IF formula on excel please?

Solved by E. S. in 13 mins