I have a request to create a cell with a formula that is 50% of another cell, rounded down to the nearest .95 (basically it's a clearance price).
How can I do that in excel?
I have a request to create a cell with a formula that is 50% of another cell, rounded down to the nearest .95 (basically it's a clearance price). How can I do that in excel? 


Do you really want $3.89 to become $0.95? Because that's what rounding down to the nearest 0.95 does. Also, note that for original prices of less than $1.90, this formula generates a price of $0.05, which is what you asked for but is silly. 

