Percentage
Posted by Sheila Cox (Becton) on July 14, 2001 3:09 AM
I want to get 1.5% of column H. How do I do this? Sheila
Posted by Aladin Akyurek on July 14, 2001 3:35 AM
What is in column H? Lots of numbers or just one number in say H1?
Aladin
Posted by Sheila Cox on July 16, 2001 12:41 PM
I have already figured the percentage question out thanks for your response. I now need to know how to bring a total down from one row to another without the old data in the new row showing until I start entering the new data for that row. I have a condition statement, would a IF statement work.
Posted by Aladin Akyurek on July 17, 2001 4:09 AM
Sheila,
You put things very tersely, so I have to guess.
Lets say you enter data in A from A1 on and you keep a running total in B.
In B1 enter: =IF(ISNUMBER(A1),A1,"")
In B2 enter: =IF(ISNUMBER(A2),A1+A2,"") [ copy down as far as needed ]
Is this what you want? If not, please provide more info.
Aladin
