Thread: If statemrent
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
 
Posts: 180
Default If statemrent

Hi Mac,

Check out the group for today's question...Jim May asked a similar question

HTH

--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"mac" wrote:

Hello,
I have this if statement and when I go to add 2 more if statements I get an
error. Can you help? Any help will be greatly appreciated. Thank you



=IF(C6="15764",'MA RUGS'!J10,IF(C6="14484",'MA RUGS'!I10,IF(C6="99922",'MA
RUGS'!L10,IF(C6="39300",'MA RUGS'!I10,IF(C6="49340",'MA
RUGS'!P10,IF(C6="39300",'MA RUGS'!I10,IF(C6="49340",'MA
RUGS'!P10,IF(C6="21604",'MA RUGS'!R10,0))))))))
--
thank you mac