The CHOOSE function is used to represent the extracted number with appropriate words. CHOOSE(LEFT(TEXT(B7,”000000000.00″))+1,,”One”,”Two”,”Three”,”Four”,”Five”,”Six”,”Seven”,”Eight”,”Nine”) checks if the value is zero. If it is zero, then it displays nothing. CHO...
So while people in the UK and Ghana, for example, were forking out £1.44 ($1.80) or 14 cedis ($1.24) respectively for a litre of petrol in May, Nigerians paid 185 naira ($0.40) - despite all three countries buying it from the same international market. This has been the practice...