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.
View best response
Try this in B2
=IF(ISBLANK([@Country]),SUM([@[Sell Price]]*1.2),[@[Sell Price]])
many thanks this has worked perfectly