nested if not working not sure why Help!! Please
Perhaps
=IF(A25="LB",B25 *2,IF(A25="IB",B25 *4,0))
Mike
"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
|