E90Post
 


VIBE Motorsports
 
BMW 3-Series (E90 E92) Forum > BMW E90/E92/E93 3-series General Forums > Regional Forums > UK > UK Off-Topic Discussions > Excel help



Reply
 
Thread Tools Search this Thread
      07-12-2013, 04:24 AM   #1
- Paul -
Major General
England
179

 
- Paul -'s Avatar
 
Drives: see above.
Join Date: Apr 2005
Location: Yorkshire, UK


Posts: 7,273
iTrader: (5)

Garage List
2005 320D SE  [5.00]
2005 645  [4.50]
Excel help

Hello chaps,

I'm sure this is a simple fix but I have been looking at this blank for some time.

Ignoring the figures on the spreadsheet (its just random numbers) I need C21 to show 0 if C8 is blank or 0, if C8 is not blank or 0 then it needs to show the sum of c8 minus c7

I've been playing with isblank but convinced I'm missing something simple here!!

Cheers

Paul.

Link to file https://www.dropbox.com/s/xeyoife7ag...hroughputs.xls
__________________
Appreciate 0
      07-12-2013, 04:48 AM   #2
sufchenko
Private First Class
United Kingdom
1

 
sufchenko's Avatar
 
Drives: BMW 320D SE
Join Date: Jul 2010
Location: West Yorkshire


Posts: 106
iTrader: (0)

try this as formula in C21:

=IF(ISBLANK(C8),0,C8-C7)
__________________
Driving: BMW 320D SE
Appreciate 0
      07-12-2013, 06:21 AM   #3
PowerCorrupts
Private First Class
United Kingdom
1

 
Drives: E92 325d
Join Date: Apr 2012
Location: Cambridge


Posts: 140
iTrader: (1)

I don't think the above will work when the figure is 0?

This will though;

=IF(C21="",0,IF(C21=0,0,(C8-C7)))
Appreciate 0
      07-12-2013, 08:43 AM   #4
- Paul -
Major General
England
179

 
- Paul -'s Avatar
 
Drives: see above.
Join Date: Apr 2005
Location: Yorkshire, UK


Posts: 7,273
iTrader: (5)

Garage List
2005 320D SE  [5.00]
2005 645  [4.50]
Many thanks chaps - much appreciated!
__________________
Appreciate 0
      07-12-2013, 04:51 PM   #5
1 AKY
Lieutenant
United Kingdom
6

 
1 AKY's Avatar
 
Drives: E90 330D MSport Auto
Join Date: Jul 2007
Location: UK


Posts: 400
iTrader: (1)

Rather than using 2 IF statements, using OR for your conditionality would be another option
Appreciate 0
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 10:55 AM.




e90post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST