Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Vlookup and If statement problem Vlookup and If statement problem
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
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
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
vlookup question Tony G Excel 9 03-28-2009 11:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:46 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft