Formula "Self-Changing" to Something Else

Looks like you’ve just got some nesting issues with the IF statements. Airtable is attempting to correct so that’s why it changes. (Full disclosure - I asked ChatGPT.)

Hm yeah, I would recommend adding line breaks and tabs to formulas to make them easier to debug

Here’s what your formula looks like:

IF(
	{Transaction Status} = "Order Filled", 
	IF(
		{Transaction Type} = "Sell", 
		(
			{Total Cryptocurrency Value USDT} - 
			(
				{Value per Buy Cryptocurrency USDT (from Linked Buy Transaction (From field: Linked Sell Transactions))} * 
				{Amount of Cryptocurrency}
			)
		) * 
		0.35
	), 
	IF(
		{Transaction Type} = "Buy", 
		IF(
			{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} = {Total Cryptocurrency Value USDT}, 
			(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)}) - 
				{Total Cryptocurrency Value USDT}
			) * 
			0.35, 
			IF(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} < {Total Cryptocurrency Value USDT}), 
				'Trade in progress', 
				IF(
					{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} > {Total Cryptocurrency Value USDT}
				)
			), 
			'Miscalculation'
		)

There are a couple of extra ‘)’s and the ‘Miscalculation’ line isn’t inside an ‘IF’, which seems like a typo?

Try this:

IF(
	{Transaction Status} = "Order Filled", 
	IF(
		{Transaction Type} = "Sell", 
		(
			{Total Cryptocurrency Value USDT} - 
			(
				{Value per Buy Cryptocurrency USDT (from Linked Buy Transaction (From field: Linked Sell Transactions))} * 
				{Amount of Cryptocurrency}
			)
		) * 
		0.35
	), 
	IF(
		{Transaction Type} = "Buy", 
		IF(
			{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} = {Total Cryptocurrency Value USDT}, 
			(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} - 
				{Total Cryptocurrency Value USDT}
			) * 
			0.35, 
			IF(
				{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} < {Total Cryptocurrency Value USDT}, 
				'Trade in progress', 
				IF(
					{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} > {Total Cryptocurrency Value USDT},
					'Miscalculation'
				)
			)
		)
	)
)	

​@TheTimeSavingCo,

Thanks for your reply.

I copied and pasted your version of the code into the formula field, and this time it did not “self-change” the code but where there is supposed to be the text “Trade in progress” for a particular record, it doesn’t show anything. So I’m thinking there is still something wrong with the way the IF statements are nested, or Airtable still isn’t liking the formula. As I can see it, it looks fine to me.

Hmm, your formula currently checks the following: 

{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} = {Total Cryptocurrency Value USDT}

IF(
	{Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} < {Total Cryptocurrency Value USDT}, 
	'Trade in progress',