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, 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
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