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.
Thank you!!
Then next step:
=IF(ISNUMBER(SEARCH("INV",G2)),"INV",H2*5%)
Katie,
=(G2="INV")*H2*5%
Detlef, that comes back with zero, regardless if there is INV or not.
It works in my sheet.
