Creating a IF formula without the (if false) section.

Hi,

You can try the following formula:

IF(B9=TODAY(),"It is today","")

in the above formula, part "B9=TODAY()" is condition, which checks whether cell B9 is today,

if true, it will return "It is today"

if false, it will return blank.

Cheers!

To avoid a self reference error, you must put the formula in another cell (Column D).

Formula in D2 (and Fill Down)

=IF(B2=B$1,"This is Today",C2)

The function TODAY() does what it says. Tomorrow is another day!

Regards,

Ian.

"I really don’t want it to show up blank or False. I would like the number in the box to change if the IF equation was true, otherwise leaving it alone."

Hi Sarah,

A cell can contain a value that has been entered in the cell, OR it can contain a formula and display a value generated by that formula.

If you have entered the 'number in the box' from the keyboard, or by copying it from somewhere else and pasting it into the box, then the act of entering the formula into that box will remove the number you placed there earlier.

You could use the process shown in the table below. The cell playing the part of "the box" is C2, and the number "in the box" is "6".

IF cell B2 contains today's date, the number in C2 is to double 12. If B2 is empty, or contains any date that is not TODAY, the number is to remain as it is (6).

The number in C2 (and in each other cell in column C) is generated by the formula shown below the table.

The actual numbers involved could be written directly into the formula, with 12 replacing Table 2::A$2 * 2 and 6 replacing Table 2::A$2. Doing that, though would require editing the formula if you wanted to change either value.

With the base number coming from a cell on another table, that number can be changed without requiring any editing of the formula.

If the change in value in C2 cannot be calculated from the base number, it could be retrieved from a second cell on the small table, by changing the Table 2::A$2 * 2 reference to point to another cell containing the value to be placed in the cell if the expression returns TRUE.

Cell B2 of the second table contains TODAY(). It's there to display the date when the screen shot of the two tables was taken, and plays no part in the working of the formula.

Regards,

Barry

Hi Sarah,

IF needs both an if-true part and an if-false part. If you leave out the if-false, you'll see the text "FALSE" in the cell whenever the IF condition is not met,

Ian's suggestion provides the cleanest appearing result—a null string—a text value with no length, that appears identical to an empty cell.

Regads,

Barry

Hi Sarah,

Use NULL for false. The cell will appear blank.

IF(EXACT(TODAY),(A)),(VALUE),"")

Regards,

Ian.

Hi Sarah,

I would like the number in the box to change if the IF equation was true, otherwise leaving it alone.

I think that will give a "self reference" error.

I can't test because I don't understand your overall aim.

The EXACT function returns TRUE if the argument strings are identical in case and content.

EXACT(string-1, string-2)

string-1: The first string value.

string-2: The second string value.

Examples

=EXACT(“toledo”, “toledo”) returns the boolean value TRUE, because all the characters and their cases are identical.

=EXACT(“Toledo”, “toledo”) returns the boolean value FALSE, because the case of the two strings is not identical.

Regards,

Ian.