Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 30th 05, 03:20 PM
Mike T
 
Posts: n/a
Default adding a formula in a cell but when cell = 0 cell is blank

I am trying to create an invoice so when I put qty in cell A1 and the $ value
in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula
running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00
appearing in each cell, My question is how can I use this formula or
something simular to get same answer to show a blank cell when not used
--
Thanks Mike T

  #2   Report Post  
Old May 30th 05, 03:30 PM
Bob Phillips
 
Posts: n/a
Default

=IF(AND(A1<"",B1<""),B1*A1,"")

--
HTH

Bob Phillips

"Mike T" wrote in message
...
I am trying to create an invoice so when I put qty in cell A1 and the $

value
in cell B1, cell C1 has formula =B1*A1, thats fine, but having that

formula
running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00
appearing in each cell, My question is how can I use this formula or
something simular to get same answer to show a blank cell when not used
--
Thanks Mike T



  #3   Report Post  
Old May 30th 05, 03:32 PM
Ragdyer
 
Posts: n/a
Default

One way:

=IF(AND(B10,A10),B1*A1,"")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Mike T" wrote in message
...
I am trying to create an invoice so when I put qty in cell A1 and the $

value
in cell B1, cell C1 has formula =B1*A1, thats fine, but having that

formula
running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00
appearing in each cell, My question is how can I use this formula or
something simular to get same answer to show a blank cell when not used
--
Thanks Mike T


  #4   Report Post  
Old May 30th 05, 03:42 PM
Aladin Akyurek
 
Posts: n/a
Default

Mike T wrote:
I am trying to create an invoice so when I put qty in cell A1 and the $ value
in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula
running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00
appearing in each cell, My question is how can I use this formula or
something simular to get same answer to show a blank cell when not used


Custom format the formula cell as e.g.,

[=0]"";General
  #5   Report Post  
Old May 30th 05, 04:10 PM
bj
 
Posts: n/a
Default

Try
=if(A1*B1=0,"",A1*B1)

"Mike T" wrote:

I am trying to create an invoice so when I put qty in cell A1 and the $ value
in cell B1, cell C1 has formula =B1*A1, thats fine, but having that formula
running down C2 C3 C4 etc where there is nothing entered yet, I have $0.00
appearing in each cell, My question is how can I use this formula or
something simular to get same answer to show a blank cell when not used
--
Thanks Mike T



  #6   Report Post  
Old May 31st 05, 01:08 AM
Duke Carey
 
Posts: n/a
Default

Aladin -

Better to use a custom format such as

#,##0.00_);(#,##0.00);;

The spot between the second & third semicolons is for the zero format. If
left blank, zeros are suppressed. The last semicolon is for text values.
Since it, too, is blank in my example, no text values would show either

Duke

"Aladin Akyurek" wrote in message
...
Mike T wrote:
I am trying to create an invoice so when I put qty in cell A1 and the $
value in cell B1, cell C1 has formula =B1*A1, thats fine, but having that
formula running down C2 C3 C4 etc where there is nothing entered yet, I
have $0.00 appearing in each cell, My question is how can I use this
formula or something simular to get same answer to show a blank cell when
not used


Custom format the formula cell as e.g.,

[=0]"";General





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
numbers being entered show in formula bar but not in cell? Jim in Florida Excel Discussion (Misc queries) 2 May 13th 05 06:36 PM
need help creating formula based on cell value Brad Excel Discussion (Misc queries) 3 April 1st 05 07:51 PM
Cell shows formula and not the result of the formula. stumpy Excel Worksheet Functions 2 January 14th 05 04:44 PM
looking for a formula Amanda Excel Worksheet Functions 5 January 5th 05 07:37 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 03:25 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017