E90Post
 


MINHS Auto Care Center
 
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
- Paul -'s Avatar
England
179
Rep
7,274
Posts

 
Drives: see above.
Join Date: Apr 2005
Location: Yorkshire, UK

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
sufchenko's Avatar
United Kingdom
1
Rep
106
Posts

 
Drives: BMW 320D SE
Join Date: Jul 2010
Location: West Yorkshire

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
Rep
140
Posts

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

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
- Paul -'s Avatar
England
179
Rep
7,274
Posts

 
Drives: see above.
Join Date: Apr 2005
Location: Yorkshire, UK

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
1 AKY's Avatar
United Kingdom
6
Rep
402
Posts

 
Drives: E90 330D MSport Auto
Join Date: Jul 2007
Location: UK

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 09:50 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