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%)
Detlef_Lewin We're closer! :)
If it finds INV, I need it to say INV. If it doesn't find INV, I need it multiply H2 by 5%.
Then next step:
=IF(ISNUMBER(SEARCH("INV",G2)),"INV",H2*5%)