corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Excel formula help


New Topic
New Poll 		  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel formula help
Tom J
Organiser: South Wales
Premium Member

Registered: 8th Sep 03
Location: Bridgend
User status: Offline
16th Mar 13 at 05:41   View User's Profile U2U Member Reply With Quote
Don't know if this is possible but here goes:

I4 = B4 * C2
L6 = I4 * B5
L7 = I4 * B6
L8 = I5 * B6
L9 = I4 * B7
L10 = I5 * B7
L11= I6 * B7

L24=SUM(L6:L10)

L25=COUNTA(L6:L10)

L26=(L24-(L25*C2))

I need a formula to tell me how many (the least amount ideally) of B cells need to be of zero value for L26 to be less than Zero
pow
Premium Member

Avatar

Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
16th Mar 13 at 09:06   View Garage View User's Profile U2U Member Reply With Quote
If you'd like to knock up a mock spreadsheet I'll have a go for you

 
New Topic
New Poll

  Related Threads Author Forum Replies Views Last Post
Excel Help Darren General Chat 3 702
4th Mar 04 at 11:51
by ipswichcorsa		  
Excel Formula Help.. Bart Geek Day 6 765
7th Dec 06 at 07:59
by Bart		  
Working out 15% (VAT) in Excel. deano87 Geek Day 24 826
10th Feb 09 at 19:25
by deano87		  
Excel formula quick help strick206 Geek Day 6 303
20th Sep 10 at 11:49
by strick206		  
Excel Formula RCS Geek Day 1 381
6th Jul 12 at 13:39
by Ian		  

Corsa Sport » Message Board » Off Day » Geek Day » Excel formula help 28 database queries in 0.0083728 seconds