[Solved] Creating if then formula with 2 choices

[carwena]

I am trying to create an if then formula with 2 possible choices where one of the choices is a blank cell. This is what I have, which is not right but kind of describes what I'm trying to do. =IF(D4=30 THEN (E4=23) IF D4=90 THEN BLANK)

[robleyd]

Assuming this formula is to be in E4, what result do you want if D4 is neither 30 or 90?

If the formula is not to be in E4, please give a little more detail of exactly what you are trying to achieve. Note that a formula can only affect the cell in which it is located.

[carwena]

Thanks for responding so quickly! I'm try to set up Rx reorder reminder sheet. Some Rx's have a 30 day supply while others a 90 day. I have included a sheet (prescription sample) trying to illustrate what I mean.

[MrProgrammer]

I'm try to set up Rx reorder reminder sheet. Some Rx's have a 30 day supply while others a 90 day.

Look in my attachment at the formulas in columns F and G. Rows 6 to 16 also contain the formulas but they are written to show nothing until data is entered in columns D and E.

202202260027.ods

Formulas for 30 days and 90 days

(14.8 KiB) Downloaded 128 times

=IF(D4=30 THEN (E4=23) IF D4=90 THEN BLANK)

An IF function uses this syntax =IF(condition;result_when_true;result_when_false). All IF functions return a result whether the condition is true or false, so you will always want to supply the appropriate result_when_false value. The first tutorial below will help you with creating formulas which have multiple situations to be tested. You never use the keyword THEN in the function.

You do not want to use =TODAY() in column E because that formula is recalculated each time you open the document, so the dates in your spreadsheet would change in the future! Just type the current date in the cell and do not use a formuia in column E. A shortcut for a day in the current month, when you know the day of the month, is to type that followed by a slash. Thus in February to enter February 26 you would type 26/ and press Enter. On a Mac, the day of the month is always shown in the Dock.

Day of the month in the Dock

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know   ← You should read this, carwena
[Tutorial] Mac FAQ   ← Many Mac questions are answered here

[robleyd]

Given the layout you have, you don't seem to need a nested IF; just a simple IF for each of the two re-order periods. See F12:G13 in the attached file.

[carwena]

Thank you for responding! I think it has to be nested because the reorder date is in 21 or 76 not 30 & 90.