🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Using IF to determine which sum to use

User: "Altair Forum User"
Altair Employee
Updated by Altair Forum User

Hi,

 

I'm trying to use an if statement as I would in Excel, but not getting anywhere. This is my formula. They are all numeric fields.

 

 

IF(([Total Amount]*[Exchange Rate])=0,[Total Amount],[Total Amount]*[Exchange Rate])

 

Does anyone have an idea please? I'm using classic.

 

Thanks

Natalie

Find more posts tagged with