Hello, please can someone advise if it is possible to return a value of pounds and pence in two separate cells?
For example: 75 x £0.37 = £27.75
A B C D
75 0.37 27 75
Column C is the pounds (formula =A*B)
Column D is the pence (formula=A*B)
Hope to hear, thank you in advance.
Bookmarks