Decimal Places

[mate]

I have the following text and sum function but the result is a
currency figure and i therefore need it to calculate the sum to 2
decimal places only - it currently brings it up as 4 decimal places.

a1 ="For payments within 14 days of invoice date, please deduct 5%
discount of £" &SUM(D26)*5%

Is it possible to specify this in a single cell function? Or will I
have to split it to 2 cells - one for text and one for result?

TIA.

Jan

 

[Don Guillett]

try
=TEXT(8*13450.03456,"#.00")

 

[Peo Sjoblom]

Try this

="For payments within 14 days of invoice date, please deduct 5% discount of
£" &ROUND(D26*5%,2)

or maybe

=IF(D26="","",="For payments within 14 days of invoice date, please deduct
5% discount of £" &ROUND(D26*5%,2))

 

[mate]

Thank you - that worked

Jan

Try this

="For payments within 14 days of invoice date, please deduct 5% discount of
£" &ROUND(D26*5%,2)

or maybe

=IF(D26="","",="For payments within 14 days of invoice date, please deduct
5% discount of £" &ROUND(D26*5%,2))