Here is my text and formula it is all in one cell
="2 Years Parts & 1 Year Labour (Ex VAT) = £"&(I6-I3) &" (Inc VAT) =£"& (I6-I3)*0.2+(I6-I3)
i need the answer to be to 2 decimal places
Here is my text and formula it is all in one cell
="2 Years Parts & 1 Year Labour (Ex VAT) = £"&(I6-I3) &" (Inc VAT) =£"& (I6-I3)*0.2+(I6-I3)
i need the answer to be to 2 decimal places
You can do it like this:
="2 Years Parts & 1 Year Labour (Ex VAT) = £" & TEXT((I6-I3),"0.00") &" (Inc VAT) =£" & TEXT((I6-I3)*0.2+(I6-I3),"0.00")
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks