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%)
Katie,
=(G2="INV")*H2*5%
Detlef, that comes back with zero, regardless if there is INV or not.
It works in my sheet.
I'm not sure why it's not working in my spreadsheet. It just comes back with zeros. Please tell me if I'm
missing something obvious! :D
