Hi Everyone!
Been using excel for years now, and am trying to get an if formula to work based on a condition, whereby it then processes one of two possible formulas. I've changed the syntax a little on this post to give you an idea of what I'm trying to acheive, basically depending on the value, a different formula is used. Can't seem to get the syntax right? Any ideas?
=IF(F15<4,use formula a, otherwise use formula b)
formula a)
IF(B24>0,($H$17*1.564)*(VLOOKUP(A24,INDEX!$A$5:$E$729,3,FALSE))*(VLOOKUP(A24,INDEX!$A$4:$E$729,4,FALSE))+(VLOOKUP(A24,INDEX!$A$5:$E$729,5,FALSE)),””)
formula b)
IF(B24>0,($H$17*1.564)*(VLOOKUP(A24,INDEX!$A$5:$E$729,3,FALSE))*(VLOOKUP(A24,INDEX!$A$4:$E$729,7,FALSE))+(VLOOKUP(A24,INDEX!$A$5:$E$729,5,FALSE,””)))))))
Rgds,
B