How do you write this formula that is part of nested if statements.

for e.g SEARCH FOR A KEY WORD IN ONE CELL AND A VALUE BETWEEN 3 TO 10 IN ANOTHER, IF BOTH ARE TRUE THEN RETURN ,10 IF EITHER ARE NOT TRUE THEN GO TO THE NEXT IF ARGUMENT.

Kind regards,

Matt