Advanced spreadsheet help needed

[Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,
im tryin to setup a spreadsheet but the stuff i learnt was oh so long ago.......

i need a cell to look at another cell and if the value is greater then 0 i want it to display the number in the other cell, but if its less show a dash. shows a dash all the time until a value is put into 2nd cell........

sorta like this......

**in a2**
if a1 is equal to 0 show a dash
if a1 is greater then 0 show whatever is in a2



Also in a3, if a2 is greater then 0, i want that value x100, but if it equals 0 show a dash

im guna repeat this on 5 rows and want f1 to show the total of a3, b3, c3, d3, e3 even though there might be a dash not a number.

if anyone can sort this i would be eternally greaterful!!!!!


Related:

2 replies

greaterful lol didnt read tht before i posted it.
Also i want to make a cell equal 0 even if theres nothing in it..........

alot of help neededf i should of put lol
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Use following Formula in
A2
=IF(A1=0,"-",A1*100)
B2
=IF(B1=0,"-",B1*100)
C2
=IF(C1=0,"-",C1*100)
D2
=IF(D1=0,"-",D1*100)
E2
=IF(E1=0,"-",E1*100)
there no need of row a3,b3,c3,d3,e3

and now put formula in
F1
=SUM(A2:E2)