Forum Discussion
Solved
Multiple IF function
Hello! The short version: I need to put a formula in J2 that will read G2 for INV. If it finds INV it puts INV in J2. If it doesn't find INV, J2 becomes the multiplication of H2 times 0.05. T...
Then next step:
=IF(ISNUMBER(SEARCH("INV",G2)),"INV",H2*5%)
The previous formula worked out at replier's workbook because INV was the only word but you have a string with INV within so it will return false always
Both formulae work the same
=IF(IFERROR(FIND("INV",G1),0)>0,"INV",H1*5%)
=IF(IFERROR(FIND("INV",G1),0)>0,"INV",H1*.05)
This will check if there is INV and will return INV if there is that word, otherwise will become H2 times 0.05
Do you use commas or semicolons?
If the answer is semicolons then this ought to work
=IF(IFERROR(FIND("INV";G1);0)>0;"INV";H1*5%)
Nope, I don't think it likes semicolons. It says the formula contains an error.
Katie,
you are probably using Excel 2003 or older.
=ISNUMBER(SEARCH("INV",G2))*H2*5%