lilla tangentbord som medföljde vid köp av iMac. Sitter här med ett excelblad och behöver ange dollartecken och upptäcker att jag inte hittar detta på mitt. So would I put for example: DOLLAR(I7,0) or DOLLAR(I7,1)? I can't seem to get the formula to work Also, all my prices are in whole number (no ¢). I know the formula goes something like this: =(B7:B38) * DOLLAR(I7,x)+DOLLAR(I38,x)+DOLLAR(J7,x)+DOLLAR(J38,x). I want to put dollar signs in front of my prices in Column I and J.This is what it would look like: =SUM ($A$1,B1) =SUM ($A$1,B2 A dollar sign forces Excel to keep pointing to A1 as you fill other cells.Home Dollar sign Excel Mac Copy a formula by dragging the fill handle in Excel for Ma
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |