IIf to return a formula or field

I do not have any problems getting the function to give me a text answer but
I need something like this IIf([machinestep]<140, [price]/2, [price]). This
was obviously not working. If the data in the field [machinestep] is less
than 140 then I want the answer to be [price] divided by 2, or the data that
is in the [price] field if it is not less than 140. I do not have a problem
with getting the first part of the string to give me "text", "text1" but not
the other way. Thanks for any advice!
.

Relevant Pages

  • Re: Problem with Exporting Survey Results to Excel Spreadsheet
    ... Please advice on ... Price? ... > separate columns if you are interested ... Prev by Date: ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Getting Depressed About eBay. Advice?
    ... Honestly the best advice is just buy what you want from Frenchy! ... can't beat him for price, service and he throws in extras and always a ... Prev by Date: ...
    (alt.smokers.pipes)
  • Re: Canon PowerShot A610
    ... Jesse wrote: ... > Can someone give some advice about A610? ... > The current price of A610 is $299. ... Prev by Date: ...
    (rec.photo.digital)
  • Re: how do I lookup multiple values
    ... > How do I look up the price of ice - cream in the month of Jan. or lookup the ... > price of coffee in Mar based on an input from user on both product and month? ... Please advice. ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • BC--DVD
    ... By the way--did anyone pick up the DVD yesterday? ... Any advice on the where to find the best price? ... Prev by Date: ...
    (rec.music.artists.springsteen)