Count If other than 1

[cjmcfg]

I'm very new to crystal, SQL, VB, and Access. I'm not really sure how to format a formula
I have an input from access into my report and i need to create a formula that will say

if this field equals a 1 or 3 add 1 but if the field equals 2 or 4 add .5

i know it's simple but any help would be appreciated

 

[Turkbear]

Hi,
A couple of ways,but the simplest is probably:
@NewValue

If {field} in [1,3] then
{field} + 1
else
If {field} in [2,4] then
{field} + .5
Else
{field}

To Paraphrase:"The Help you get is proportional to the Help you give.."