Hi, very simple one.
Need the title pseudocode to work in a single cell. I can do it using a helper cell but would rather do it with 1 if at all possible.
Thanks a bunch.
Current way I'm doing it, just for your information:
Hidden helper cell F73: =AVERAGE(A1:A10)-10
Table cell F20: =IF(F73>0,F73,"")
Last edited by ThomasCarter; 11-15-2012 at 08:14 AM.
=if(average(a1:a10)-10>0,average(a1:a10)-10,"")
Gary's Student
Hey Jakob,
That does exactly what I asked for but I have just realised that's not what I want! Hah!
I want it to ignore values under 10 but do the same thing as above. Example below...
A1 = 9
A2 = 11
A3 = 4
A4 = 13
Average would be 2, as it's only doing (11+13)/2 -10
To average of certain values:
=AVERAGE(IF(A1:A4<10,A1:A4))
This is an array formula. It must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key.
=AVERAGE(IF(A1:A10>10,A1:A10))-10
Did the job in the end. (Only addition to your wonderful advice was adding the -10)
So is an array formula basically just a series of different forumlas that run step by step in the same cell?
Thanks.
Last edited by ThomasCarter; 11-15-2012 at 11:30 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks