nested if not working not sure why Help!! Please

  • Thread starter Thread starter IainB
  • Start date Start date
I

IainB

I have manged to get the following to work

=IF(A23="IB",B19 *2,0)

however when i try to complete a nestedif so that i can look for more than
just one set of initials the code does not work

below is my nestedif
=IF(A25="LB",B25 *2,0,IF(A25="IB",B25 *4,0))


I am very very new to this so im abit lost and any advise would be cool

Please can you explain in laymen terms when you respond as i say im very new

Kind Regards

Iain
 
Mike's should do it for you. It's because you had the an extra
argument in there. the ,0, if (... makes your second if statement
invalid. Hope that helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can someone test this IF function for me, I'm not sure that it works. 3
VBA not working 1
Help with nested IF statements 2
why If, THEN does not work 5
Nested If Function to be converted into a user-defined customfunction 1
Please Help! Virus? Avast, Firefox, Windows update quit working 4
not sure if michrophone is working 1
Nested If statement -- please help :) 8

Back
Top