Advanced spreadsheet help needed
Closed
Marshski
-
Apr 7, 2011 at 05:24 PM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 8, 2011 at 01:44 AM
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Apr 8, 2011 at 01:44 AM
Related:
- Advanced spreadsheet help needed
- Advanced systemcare - Download - Cleaning and optimization
- Snapchat advanced settings - Guide
- Duckduckgo advanced search - Guide
- Advanced pdf manager - Download - PDF
- Advanced pdf password recovery - Download - File management
2 responses
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
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
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Apr 8, 2011 at 01:44 AM
Apr 8, 2011 at 01:44 AM
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)
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)
