[SOLVED] Getting =DATE formula to leave cell blank if nothing in ...
Feb 5, 2025 · Getting =DATE formula to leave cell blank if nothing in original cell Hi and thank you in advance for any help you can offer. I'm using the following formula, which is getting the …
[SOLVED] Combine multiple xlookups with multiple if statements
May 6, 2024 · Combine multiple xlookups with multiple if statements Hi there, I need to do a combo XLOOKUP with IF formula where it works through the formula in order - i.e. if 1st IF …
If Unique then formula [SOLVED] - Excel Help Forum
Aug 24, 2016 · Hi Can anyone help with a formula please. In column J I have a list of users. In column W I would like a formula which would place a “1” in the cell if the user is unique and …
[SOLVED] IF formula to return 0 instead of False - Excel Help Forum
Jan 29, 2014 · Re: IF formula to return 0 instead of False There isn’t a website, go to one of the forums, either general or formulas and functions and right under the yellow banner at the top …
Formula to Return yes or no if cells have data, but remain blank if …
Feb 18, 2025 · Formula to Return yes or no if cells have data, but remain blank if no data Column A has a due date or is blank. Column B has the completion date or is blank. Column C I need …
IF Target Cell = Yes then 1, if No = 0 how do I set this up
Mar 5, 2014 · Re: IF Target Cell = Yes then 1, if No = 0 how do I set this up Currently trying to use a formula similar to =IF (D6=Yes,1,0) but its returning me a name error, Could it be because …
If then statement? [Show result only when it's >0] [SOLVED]
Mar 29, 2018 · I need to create an IF THEN formula for a cell. Basically this but needs to be translated into excel language: (F6-B2) only if the quantity is greater than 0 Sidenote: I'd like to …
IF Function - Begins With - Excel Help Forum
Dec 1, 2016 · Re: IF Function - Begins With Would this formula work on numbers, or do I need to change the numbers to text first?
Question: How do I leave a cell blank if formula value is #N/A
Feb 20, 2008 · You can revise your formula to include the ISNA condition and return a blank e.g. =IF (ISNA (your_formula),"",your_formula) or you can use conditional formatting to change the …
IF (A cell has anything in it) - Excel Help Forum
Nov 27, 2009 · Should be an easy one. Is there any command usable in an IF statement that checks to see if a cell has a value or text in it? Like IF (A1="text or number", YES, NO). Tried …