Excel 2007 - 3 Logical Tests?

[castout85]

Hello, I am working on a homework assignment, the books method was crap so I did my own method. I am almost done except for 1 last thing. I cannot find any function that will allow for 3 logical tests. I have a screen shot here explaining what I need to happen.

\1

The only function I could think of to try was:

Please Login or Register  to view this content.

As you can see the IF function only allows for a single logical test. I have 3 logical operators im working with here.

[VBA Noob]

Try

=IF(B15="Standard 9.50",9.5,IF(B15="Express 14.50",14.5,IF(B15="Overnight 18.50",18.5,"")))

or

=IF(LEFT(B15,FIND(" ",B15)-1)="Standard",RIGHT(B15,LEN(B15)-FIND(" ",B15)),IF(LEFT(B15,FIND(" ",B15)-1)="Overnight",RIGHT(B15,LEN(B15)-FIND(" ",B15)),IF(LEFT(B15,FIND(" ",B15)-1)="Express",RIGHT(B15,LEN(B15)-FIND(" ",B15)))))

VBA Noob

[castout85]

worked

Please Login or Register  to view this content.

thanks man!!!