IIF Statement - HELP!

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

I need help with an IIF statement for the following:

If StdPrice = 0, give me "rebill"
If Part# ends with "-OSP",give me "outside processing"

I got the first part to get "rebill" but I can't figure out how to write the
"part# ends with -OSP"...

Please help!
Thanks,
Susan
 
=IIF([StdPrice]=0,"rebill",IIF(Right([Part#],4)="-OSP","outside
processing","neither rebill nor outside"))
 
Thanks Dennis!

Dennis said:
=IIF([StdPrice]=0,"rebill",IIF(Right([Part#],4)="-OSP","outside
processing","neither rebill nor outside"))

susan said:
I need help with an IIF statement for the following:

If StdPrice = 0, give me "rebill"
If Part# ends with "-OSP",give me "outside processing"

I got the first part to get "rebill" but I can't figure out how to write the
"part# ends with -OSP"...

Please help!
Thanks,
Susan
Click to expand...
Click to expand...
 
Back
Top