I want to create a formula that takes information from 2 fields and displays the answer in a 3rd for example 

if field A is 10 and field B is 10 display A in the 3rd field

 

thanks  

 

Adam

17 minutes ago, Adam Masters said:

if field A is 10 and field B is 10 display A in the 3rd field

I am afraid the logic of your example escapes me. And what does this have to with Server Administration?

 

is this not a file maker forum

 

FieldC:

 Case ( FieldA = FieldB ; "A" ; "B" ) 

This will display "A" in field C if the two fields are equal but if you have more logic such as ranges or > or < that may take a bit further explanation of what your after...

(PS moved topic to this forum)

also this is a good read https://fmforums.com/guidelines/

Thank you 

I have looked at that but what I want to do is

Field A = 10 and B = 10 Display A

but then 

if A=20 B=20 display B

and A=30 B=20 Display C

and so on

thanks

 

Adam

Instead of (or in addition to) giving examples, explain the rule that needs to applied here. I, for one, cannot see the logic that would explain the results you show.

 

Field A	Field B	Field C
10	10	A
20	20	B
30	20	?

I am not seeing a progression that can be handled by math to arrive at result.

More detail is needed. 

there is a table I am working off so field c will have to be data that I enter 

ok read the sheet you sent me so will try and explain a bit better I would like to enter a number value in field a and a number value in field B then pending on the answer a predetermined letter will be shown in field C

 

Field A number from drop down list

Field B number from drop down list

Field C will take the results for fields A and B the display a letter which is predetermined for the result

In this case if you have a table of A & B and C and all the logic is arbitrary then as users select A & B the value C would be looked up or auto enter calc - no math. 

you would related this library table with multi predicates on Field A & Field B.

Lookup.fmp12

 

Sample file.

I've got that I should be able to work the rest out