Advanced spreadsheet help needed Closed

Question

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!!!!!


Configuration: Windows Vista / Internet Explorer 7.0

Marshski · Answer

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

RWomanizer · Answer

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)

Advanced spreadsheet help needed

2 responses

Similar discussions

Subscribe To Our Newsletter!