if then statement. . . .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can Anyone help? I need this to return a zero for the jewelery value if the
currentctw is not zero. The jewelrylinetotal should be zero if the currentctw
is more than zero. . . thanks!

JewelryLineTotal:
CCur(IIf([CurrentCTW],0)=0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)/100),Nz([CurrentCTW],0)))
 
how about

JewelryLineTotal:
CCur(IIf(Nz([CurrentCTW],0) > 0,
0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)/100))

hth


SD Diamonds said:
Can Anyone help? I need this to return a zero for the jewelery value if the
currentctw is not zero. The jewelrylinetotal should be zero if the currentctw
is more than zero. . . thanks!

JewelryLineTotal:
Click to expand...
CCur(IIf([CurrentCTW],0)=0,(([Quantity]*[AdjustedPrice])*(1-[Discount])*100)
/100),Nz([CurrentCTW],0)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal Formula 1
Division by Zero Error 1
Nz or Iif 8
qry FORMULA ISSUE 2
Report totals off by a couple cents. 4
Combining IF Statement and Vlookup 0
IIF statement 1
QRY FORMULA ISSUE 4

Back
Top