Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the value of a formula if 1 cell has a value of zero.
I have a spreadsheet set up and would like to hide the value of a formula if one cell has a zero value. for example... A1, value is 0 A2, value is 22 A3 (formula) is A1 + A2 But if A1 is zero, I want A3 to show nothing, how do I do this? thanks in advance -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=531995 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the value of a formula if 1 cell has a value of zero.
=if(A1=0,0,A1+A2) "duugg" wrote: I have a spreadsheet set up and would like to hide the value of a formula if one cell has a zero value. for example... A1, value is 0 A2, value is 22 A3 (formula) is A1 + A2 But if A1 is zero, I want A3 to show nothing, how do I do this? thanks in advance -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=531995 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the value of a formula if 1 cell has a value of zero.
=IF(A1=0,"",A1+A2)
-- Gary''s Student "duugg" wrote: I have a spreadsheet set up and would like to hide the value of a formula if one cell has a zero value. for example... A1, value is 0 A2, value is 22 A3 (formula) is A1 + A2 But if A1 is zero, I want A3 to show nothing, how do I do this? thanks in advance -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=531995 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the value of a formula if 1 cell has a value of zero.
You could probably use an if statement :
=if(A1=0,"",A1+A2) or you could use conditional formatting, depending on what you want to do exactly. Neda "duugg" wrote: I have a spreadsheet set up and would like to hide the value of a formula if one cell has a zero value. for example... A1, value is 0 A2, value is 22 A3 (formula) is A1 + A2 But if A1 is zero, I want A3 to show nothing, how do I do this? thanks in advance -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=531995 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the value of a formula if 1 cell has a value of zero.
Hi,
In A3, =IF(A1=0,"",A1+A2) Regards, Bondi |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding the value of a formula if 1 cell has a value of zero.
If I'm using this formula... =IF(F24="","",F22+F24) In cell F26 and this formula =IF(F20="","",F18+F20) is in cell F22 and 1 is in cell F24 I got a #value! error Why is this the case when there is indeed a number 1 in cell F24? -- duugg ------------------------------------------------------------------------ duugg's Profile: http://www.excelforum.com/member.php...o&userid=33372 View this thread: http://www.excelforum.com/showthread...hreadid=531995 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
looking for a formula | Excel Worksheet Functions |