Text version of formula

  • Thread starter Thread starter sturae
  • Start date Start date
S

sturae

I Have Been Asked To Enter The Text Version Of The Formulas Below. Usin
No Equals Or $ Signs. Can Anyone Help???

=subtotal (9,b17:b29)

=subtotal (1,d15:d25
 
By "Text Version" do you mean "describe what the formula is doing in
English", or do you mean something else?
Rgds,
ScottO

in message
|
| I Have Been Asked To Enter The Text Version Of The Formulas Below.
Using
| No Equals Or $ Signs. Can Anyone Help???
|
| =subtotal (9,b17:b29)
|
| =subtotal (1,d15:d25)
|
|
| --
| sturae
| -------------------------------------------------------------------
-----
| sturae's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=29984
| View this thread:
http://www.excelforum.com/showthread.php?threadid=496793
|
 
This is the question asked:


USE DATA FILTERING AND APPROPRIATE SUBTOTAL FUNCTIONS TO
CALCULATE
THE FOLLOWING AMOUNTS.
NOTE: YOU MUST TYPE YOUR ANSWERS IN TO THE YELLOW HIGHLIGHTED AREAS
AFTER
YOU HAVE WRITTEN THE FORMULAE AND PERFORMED THE FILTER ELSEWHERE
IN THE SHEET. DO NOT ENTER FORMULAE TO THE YELLOW AREAS - ANSWERS
ONLY.

THE AVERAGE PRICE OF ALL SHARES WITH A DIVIDEND OF MORE THAN
£0.20
THAT WERE NOT UK OWNED. ANSWER TO G8. 1.95
ENTER THE TEXT VERSION OF THE FORMULA USED TO G9 (NO EQUALS OR $
SIGNS).
THE TOTAL DIVIDEND ON ALL SHARES WITH A PRICE OF LESS THAN £2.50
THAT WERE PURCHASED BEFORE 1994. ANSWER TO G11 0.85
ENTER THE TEXT VERSION OF THE FORMULA USED TO G12 (NO EQUALS OR $
SIGNS)

Share name Price (£) No. held Dividend (£) Purchase Year UK owned = 1
Agricola 0.65 1 0.12 1990 1
Cathedral Life 2.43 1 0.34 1990 1
Commercial Plus 1.67 1 0.21 1989 0
MBI 0.99 1 0.18 1990 1
 
Back
Top