View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IainB IainB is offline
external usenet poster
 
Posts: 3
Default nested if not working not sure why Help!! Please

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