OUTPUT your job! Excel manner
Formatting an Excel:
1. put comma, between thousands, millions, 1,000,000, not 1000000, get rid of fraction as well. not 1000000.11, but 100,000
sum(A1:A7), this function when dragged right will adapt to sum(B1:b7)
=IF(ISERROR((1/ SEARCH("15",$A2))),0, (SEARCH("15",$A2)/ SEARCH("15",$A2))) THIS WILL KEEP constant to right, will change to $A3 when dragging down
(after paste, pasted is selected and you can replace anything within this selection)
$A$1??
1. put comma, between thousands, millions, 1,000,000, not 1000000, get rid of fraction as well. not 1000000.11, but 100,000
sum(A1:A7), this function when dragged right will adapt to sum(B1:b7)
=IF(ISERROR((1/ SEARCH("15",$A2))),0, (SEARCH("15",$A2)/ SEARCH("15",$A2))) THIS WILL KEEP constant to right, will change to $A3 when dragging down
(after paste, pasted is selected and you can replace anything within this selection)
$A$1??
posted by hunter at 4:01 AM
0 Comments:
Post a Comment
<< Home