SOLVED

Nested =IF() Formula Assistance please

Copper Contributor

 

Please assist with making corrections to my formula

 

=if(=if((Right(Left(A57,8),3))="WW6",(Right(Left(A57,7),2)),=if((Right(Left(A57,8),3))="CO6",(Right(Left(A57,7),2)),(Right(Left(A57,8),3)))))

1 Reply
best response confirmed by KCDWard (Copper Contributor)
Solution
OK Got it.
=IF(RIGHT(LEFT(A57,8),3)="WW6",(RIGHT(LEFT(A57,7),2)),IF(RIGHT(LEFT(A57,8),3)="CO6",(RIGHT(LEFT(A57,7),2)),(RIGHT(LEFT(A57,8),3))))

Boy things have changed since I use to use this program.
1 best response

Accepted Solutions
best response confirmed by KCDWard (Copper Contributor)
Solution
OK Got it.
=IF(RIGHT(LEFT(A57,8),3)="WW6",(RIGHT(LEFT(A57,7),2)),IF(RIGHT(LEFT(A57,8),3)="CO6",(RIGHT(LEFT(A57,7),2)),(RIGHT(LEFT(A57,8),3))))

Boy things have changed since I use to use this program.

View solution in original post