Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Leave Blank if No Value


Hi

I am trying to use the below formual

=IF(B17="","",B6:B17)

But it is only giving me the value in B17 rather that the total from
B6 to B17.

Can anyone tell me where I am going wrong

many thanks

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default Leave Blank if No Value

On Jan 28, 5:40*am, Linexe wrote:
Hi

I am trying to use the below formual

=IF(B17="","",B6:B17)

But it is only giving me the value in B17 rather that the total from
B6 to B17.

Can anyone tell me where I am going wrong

many thanks


try =IF(isblank(B17),"",sum(B6:B17))
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default Leave Blank if No Value

Use
=IF(B17="","",sum(B6:B17))

"Linexe" wrote:


Hi

I am trying to use the below formual

=IF(B17="","",B6:B17)

But it is only giving me the value in B17 rather that the total from
B6 to B17.

Can anyone tell me where I am going wrong

many thanks

.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Leave Blank if No Value

Hi

Try this

=IF(B17="","",SUM(B6:B17))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Linexe" wrote:


Hi

I am trying to use the below formual

=IF(B17="","",B6:B17)

But it is only giving me the value in B17 rather that the total from
B6 to B17.

Can anyone tell me where I am going wrong

many thanks

.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default Leave Blank if No Value

Many thanks everyone for your help...


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Leave cell as BLANK jun duran Excel Discussion (Misc queries) 3 July 29th 09 04:42 PM
I need to know how to leave the cell blank Peter Excel Worksheet Functions 6 May 12th 08 11:19 PM
To leave the cell Blank Steved Excel Worksheet Functions 8 April 2nd 08 09:48 PM
Leave cell blank Steved Excel Worksheet Functions 7 April 19th 07 10:07 PM
leave cells blank #2 Mary Excel Worksheet Functions 2 September 2nd 05 12:29 AM


All times are GMT +1. The time now is 09:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"