Hi,
I have unique requirement. I am wholesaler of furniture and other household products. I need to sell my products which ends with 4.99. I usually get the data feed from different suppliers but I need to write a formula in excel that when pricing data loaded in column it converts that selling price ends with 4.99. For example, if one of my product price is 66.99 then it should converts to 64.99. Another example is if the price is 11.99 then it should converts to 14.99.
Can this be achieved in excel? Please advise.
Thanks in advance.
I have unique requirement. I am wholesaler of furniture and other household products. I need to sell my products which ends with 4.99. I usually get the data feed from different suppliers but I need to write a formula in excel that when pricing data loaded in column it converts that selling price ends with 4.99. For example, if one of my product price is 66.99 then it should converts to 64.99. Another example is if the price is 11.99 then it should converts to 14.99.
Can this be achieved in excel? Please advise.
Thanks in advance.