AboutPricing

Get instant live expert help on if true excel

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    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