Hi,
I am using the IF formula with Partial Word match and need to have the true output to be a SUM formula. How would I do this? This is what I have so far but is not working.
=IF(F2="","",
IF(ISNUMBER(SEARCH("*ritz*",F2)),"(=(J2-Z2)*0.5)",
IF(ISNUMBER(SEARCH("*westin*",F2)),"((J2-Z2)*0.25))",
IF(ISNUMBER(SERACH("*marriot*",F2)),"((J2-Z2)*0.25))",
"0"))))
Thank You in Advance
I am using the IF formula with Partial Word match and need to have the true output to be a SUM formula. How would I do this? This is what I have so far but is not working.
=IF(F2="","",
IF(ISNUMBER(SEARCH("*ritz*",F2)),"(=(J2-Z2)*0.5)",
IF(ISNUMBER(SEARCH("*westin*",F2)),"((J2-Z2)*0.25))",
IF(ISNUMBER(SERACH("*marriot*",F2)),"((J2-Z2)*0.25))",
"0"))))
Thank You in Advance
