Thread: [Solved] Vlookup and If statement problem
View Single Post
 
Old 03-24-2009, 05:10 AM
db2 db2 is offline
Novice
  
Join Date: Mar 2009
Posts: 2
db2 is on a distinguished road
Default
Peter,

The AND statements in each of your nested IF's are not required as you only have one statement to check in C20. Remove these and try again e.g. [ IF(C20="4%", 2, ], let me know if this solves your problem.

Regards,

David
Reply With Quote