IF formula, Partial word, SUM function as result

Joined
Jan 20, 2015
Messages
2
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top