News3 mins ago
Mac Numbers
Can anyone show me a formula that would return 3 different values in a cell based on the text content of another cell containing 3 different text values in apple numbers please? For example..in cells A1 to A4
A1 would either be a customer (1) "in the UK" or (2) "not in the UK" or (3) an empty cell
A2 would be the invoice net value
A3 would be the A2 x 20% if customer was in the UK
A4 would be the sum of A2+A3 or a blank or empty cell if A1 was also empty
I can return a zero for a blank A1 but I'd like to return the "" option where the cell is left blank for option 3
Any help appreciated, thanks
A1 would either be a customer (1) "in the UK" or (2) "not in the UK" or (3) an empty cell
A2 would be the invoice net value
A3 would be the A2 x 20% if customer was in the UK
A4 would be the sum of A2+A3 or a blank or empty cell if A1 was also empty
I can return a zero for a blank A1 but I'd like to return the "" option where the cell is left blank for option 3
Any help appreciated, thanks
Answers
Best Answer
No best answer has yet been selected by camioneur. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.