Services
Tools
Convert C-Style Syntax to Excel Syntax. Works especially with nested IF statements
Note: This is quite rudimentary and your mileage may vary.
if (Y2) { if (AF2<>"lookup") { M2 } else { VLOOKUP(A2,from_db!A:E,5,FALSE) } } else { "" }
Excel statement
=IF(Y2, IF(AF2<>"lookup", M2, VLOOKUP(A2,from_db!A:E,5,FALSE) ), "" )
