![]() 05 in this cell, ELSE if the decimal part of A1 is equal to or greater than. The first one reads (remember your formula is supposedly in cell A1): IF the decimal part of A1 is less than. These are a wee bit long, but they work for any number! Let's say your formula =D15/0.7 is in A1 and you can afford to spare column B:ฤก) Change your formula to round off your price to 2 digits, =ROUND((D1/0.7),2)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |