Joined: 18 Oct 2010
Online Status: Offline
Posts: 37
Topic: If then formula Posted: 18 Oct 2010 at 8:57am
Hi Folks,
I have a database field such as PA12345 and I want to write an if then formula that says "if the first 2 letters of this field equal "PA" then display $21.12."
Is it possible to have the formula only look at the first 2 letters of the data for an if/then statement?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum