Question about Sharp EL-520X Advanced Scientific Calculator White BP package of 5

Open Question

My calculator shows a1 how to fix back to normal

Posted by on

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to calculate an average on a cell by cell basis ?


In cell B1 put the formula =AVERAGE(A$1:A1)
Copy the formula then paste it into cells B2 through B5000

You can use any other column, of course.

Jul 22, 2014 | Microsoft Excel Computers & Internet

1 Answer

How do i calculate a difference in a percent?


If the value in A1 is 100, and the value of A2 is 120, then the formula =(A2/A1)-1 will return 0.2. If the cell containing the formula is then formatted to display as percentage it will show as 20%.

Dec 13, 2013 | Microsoft Excel for PC

1 Answer

How do I get the numbers to appear normal. They are showing as expontential figures i.e. 1.6859 04?


To switch out of scientific notation and get back to fixed decimal notation, press the f key followed by the number of digits you want to the right of the decimal point. For example, to get the 12C to show dollars and cents, press f 2.

Dec 21, 2010 | HP 12c Calculator

1 Answer

How to calculate an amount in cell up to a constant amount


Lets say you want Cell A1 is the number that you want to determin which column you want it to go in...try this formual you might need to tweek it or message back and tell me what you need ----First Column----- =IF(AND(500,000>=$A1,$A1>=0),A1," ")
----Second Column----- =IF(AND(2,000,000>=$A1,$A1>=500,001),A1," ")
-----Third Column---- =IF(AND(5,000,000>=$A1,$A1>=2,000,001),A1," ")
so this way it will only appear in the column that it fits in and you can replace A1 with the formula

Jun 25, 2009 | Microsoft Excel for PC

1 Answer

Show two decimal places


Input the following and try:
  1. Press 2ndF and . the point button. This changes the screen to FIX DEG
  2. Press 2ndF +/- 2 Answer shown is to 2 dec. pl.
  3. If you want it to 5 decimal places, Press 2ndF +/- 5 answer shown is to 5 d.p. and so on
For normal, just take calculator out of FIX so just DEG shows.

Couldn't find you a YouTube video, so text will have to do.


crimsonnightt@hotmail.com

Apr 01, 2009 | Sharp EL-738 Scientific Calculator

1 Answer

Calculation of end date in format dd/mm/yy


Assuming you put the start date in cell A1, put this formula:

=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1))

in the cell where the result wanted to be appeared.

P.S.: If this information was helpful, please rate this solution.

Mar 12, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Microsoft Excel Calculation


for example if your numbers are in cells A1, B1 and C1
=MIN(A1:C1)+MEDIAN(A1:C1)

only works for 3 numbers as you requested.

Sep 01, 2008 | Microsoft Excel 2000 Step by Step...

2 Answers

Formula for calculating the days beween months


for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

1 Answer

Multiple arguments in excel


Okay, here's a possible solution--based on my interpretation of your problem.

Suppose you have some value in cell B1, and the month (either Jan, Feb, or Mar) is stored in cell A1. The formula in C1, which performs calculations based on which month appears in A1, is as follows:

=IF(A1="Jan",B1*0.25,IF(A1="Feb",B1*0.3,IF(A1="Mar",B1*0.4)))

In this example, the value in B1 is multiplied by .25 if the month is Jan, by .3 if it's Feb, and .4 if it's Mar.

Nov 09, 2007 | Computers & Internet

Not finding what you are looking for?
Sharp EL-520X Advanced Scientific Calculator White BP package of 5 Logo

Related Topics:

31 people viewed this question

Ask a Question

Usually answered in minutes!

Top Sharp Office Equipment & Supplies Experts

Anthony Karuku

Level 2 Expert

255 Answers

k24674

Level 3 Expert

7993 Answers

CheckitRight
CheckitRight

Level 3 Expert

1362 Answers

Are you a Sharp Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...