Tech Support Guy banner

Multiple Formula's In One Cell | Excel

1002 Views 3 Replies 2 Participants Last post by  etaf
I am currently using the formula =SUM(B3*140%) to get a mark-up of 40% when entering a price, but I would like to round this up to the nearest £0.50. Please see spreadsheet attached.
Is there anyway to add this formula along with the current one?

Attachments

Status
Not open for further replies.
1 - 4 of 4 Posts
try
=CEILING(SUM(b3*140%),0.5)
Hero! Thank you so much ;)
you are welcome
1 - 4 of 4 Posts
Status
Not open for further replies.
Top