Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
when i apply a ifor formula and if there is a formula in source cell the
result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
Can you please post example(s) of your formula(e).
"M.Ummer Malik" wrote: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
if(or(a2=0,a2="",0,...)
.... = your formula hth regards from Brazil Marcelo "M.Ummer Malik" escreveu: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...) Marcelo Wrote: if(or(a2=0,a2="",0,...) .... = your formula hth regards from Brazil Marcelo "M.Ummer Malik" escreveu: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=555981 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...) Marcelo Wrote: if(or(a2=0,a2="",0,...) .... = your formula hth regards from Brazil Marcelo "M.Ummer Malik" escreveu: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=555981 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...) Marcelo Wrote: if(or(a2=0,a2="",0,...) .... = your formula hth regards from Brazil Marcelo "M.Ummer Malik" escreveu: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=555981 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...) Marcelo Wrote: if(or(a2=0,a2="",0,...) .... = your formula hth regards from Brazil Marcelo "M.Ummer Malik" escreveu: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=555981 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...) Marcelo Wrote: if(or(a2=0,a2="",0,...) .... = your formula hth regards from Brazil Marcelo "M.Ummer Malik" escreveu: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=555981 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
hopfully Marcelo intended =if(or(a2=0,a2=""*)*,0,...) Marcelo Wrote: if(or(a2=0,a2="",0,...) .... = your formula hth regards from Brazil Marcelo "M.Ummer Malik" escreveu: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=555981 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
IMY FORMULA IS
=IF(OR(G510,I510),($J$45+SUM($G$47:G51))-SUM($I$47:I51),"") "Toppers" wrote: Can you please post example(s) of your formula(e). "M.Ummer Malik" wrote: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
AND
=IF(OR(E290,I290,M290,Q290,U290),SUM(E29,I29, M29,Q29,U29,Y29),"") "Toppers" wrote: Can you please post example(s) of your formula(e). "M.Ummer Malik" wrote: when i apply a ifor formula and if there is a formula in source cell the result is displaying 0 zero i whish to keep is blank in result cell if result is 0' if all source cells are empty the result is comming as blank.(if or formula false) |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
M.Ummer Malik Wrote: AND =IF(OR(E290,I290,M290,Q290,U290),SUM(E29,I29, M29,Q29,U29,Y29),"") no problem in this formula. its correct. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=555981 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Equity buildup calculation | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a check box to accept a calculation | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |