 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2007Eliminate FALSE
=IF(AND(V2="monthly",Y2="January"),$U2) works great when statements are true. How do I say "if false then leave the cell alone?" One way: =IF(AND(V2="monthly",Y2="January"),$U2,) which returns a value of 0, or: =IF(AND(V2="monthly",Y2="January"),$U2,"") Which renders nothing displayed in the cell.  SignatureHTH |:>) Bob Jones [MVP] Office:Mac > =IF(AND(V2="monthly",Y2="January"),$U2) > > works great when statements are true. How do I say "if false then > leave the cell alone?" > =IF(AND(V2="monthly",Y2="January"),$U2) > > works great when statements are true. How do I say "if false then > leave the cell alone?" You can't "leave the cell alone" - a formula *always* returns a result to the cell. You can return a null string: =IF(AND(V2="monthly",Y2="January"),$U2,"") but the result is a text string. If you're just displaying the result, that's probably fine - it looks blank. Some functions (e.g., SUM()) ignore text. But it may cause an error if you try, for example, to use it in a math formula: A1: =IF(FALSE,"Not false","") A2: =A1+B1 ==> #VALUE! error (where FALSE would be coerced to 0, so A2 would return the value in B1). You could instead use conditional formatting to hide FALSE returns by changing the font color to the same as the cell color. Thanks for your help. What I'm trying to do is have one column represent frequency the other would have start month. Those would then autofill in all of my month columns So, if under the frequency column I type in "monthly" And in the start date column I type in "January" The result would be a entry in each month. If frequency = "Bi-monthly" And Start Date = Febuary The result would plug information into Feb, Apr, Jun, Aug, Oct, Dec If frequency = "Quarterly" And State Date = March The result would plug info into Mar, Jun, Sept, Dec Considering the formula you have helped me with so far, is this possible? I got to thinking that a cel under January would have to include a really long formula to look for all of the combinations of schedules. Hmmm... > In article <1187799713.480224.109...@m37g2000prh.googlegroups.com>, > [quoted text clipped - 21 lines] > You could instead use conditional formatting to hide FALSE returns by > changing the font color to the same as the cell color. On 8/23/07 6:14 PM, in article 1187907259.007588.260340@m37g2000prh.googlegroups.com, "dzelnio" > Thanks for your help. What I'm trying to do is have one column > represent frequency the other would have start month. Those would [quoted text clipped - 16 lines] > include a really long formula to look for all of the combinations of > schedules. Hmmm... Yes, you are correct! Not only January, but the cell for each month would have to allow for monthly, quarterly, bi-monthly, etc. I would recommend using some intermediate columns that would later be hidden. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.