# Re: Help with Formula Syntax Please (Newbie)

Solved
379 1
cancel
Showing results for
Did you mean:
6 - Interface Innovator

Field 1: is a currency field
Field 2: a checkbox
Field 3: is a currency field

I need a Formula in field 3 to do this: IF field 2 = 1, copy & paste the value in field 1 to field 3.

Thank you.

1 Solution

Accepted Solutions
7 - App Architect

@Tom_David , I believe this is what you're trying to do:

In this example, the formula for Field 3 is just

IF({Field 2}=1, {Field 1})
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
5 Replies 5
10 - Mercury

``````IF(
AND({Field 1}, {Field 2}),
IF(
{Field 1} = {Field 2},
{Field 1}
)
)``````

There's a bit of nuance I want to call out to you.
A formula won't copy and paste a value. It will simply compute and display (return) the value that it computes.
Field 3 will return a currency formatted number, but it is a formula field.

Additionally, you'll want to be sure that in the field settings for your formula field are set to display the result in a currency format.
If you don't complete this step, then you will simply be returned a number.

Take this snippet for example:

```IF(
AND(5.24, 5.24),
IF(
5.24 = 5.24,
5.24
)
)```

If you were to feed the formula field this snippet without specifying the formatting, it would return you with the default formatting of an integer, thus leaving you with just 5.

Refer to the screenshot below for steps on properly setting the formatting:

6 - Interface Innovator

Thank you... not working. Here's what I wrote in the formula:

IF(AND({Cleaning Fee}, {2021 Cleaned}), IF({Cleaning Fee} = {2021 Cleaned}, {Cleaning Fee}))

Do you see my error?

Field 1=Cleaning Fee (Currency)
Field 2=2021 Cleaned (Checkbox)
Field 3=Cleaning Charge (Formula, formatted to Currency)

10 - Mercury

Curious.
Any additional details about your fields we might be overlooking? I wasn't able to replicate any issues when tested:

I also realized that part of my formula was redundant, but they're functionally the same.

``````IF(
AND(
{Cleaning Fee},
{2021 Cleaned}
),
{Cleaning Fee}
)``````

7 - App Architect

@Tom_David , I believe this is what you're trying to do:

In this example, the formula for Field 3 is just

IF({Field 2}=1, {Field 1})
and you'll need to make sure that the "Formatting" tab in the Field 3 formula is set to Currency.
6 - Interface Innovator

Yes, that worked... and it looked a lot more like a spreadsheet formula (which is where I have spend most of my time). Thanks.