nested if not working not sure why Help!! Please
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!
On Jul 2, 1:44*pm, IainB wrote:
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
|