SOLVED

IF query

Copper Contributor

Hi,

 

I am looking to have a query where IF there is text entered into Country then invoice totals value will be overwritten and populated with sell prices value.

More details within my Excel sheet.

3 Replies
best response confirmed by G00dman (Copper Contributor)
Solution

Hi @G00dman 

 

Try this in B2

 

=IF(ISBLANK([@Country]),SUM([@[Sell Price]]*1.2),[@[Sell Price]])

@tauqeeracma 

many thanks this has worked perfectly :)

You are welcome
1 best response

Accepted Solutions
best response confirmed by G00dman (Copper Contributor)
Solution

Hi @G00dman 

 

Try this in B2

 

=IF(ISBLANK([@Country]),SUM([@[Sell Price]]*1.2),[@[Sell Price]])

View solution in original post