Formula that checks 2 seperate cells and if criteria is met enter a figure in another cell

[Willows59]

I have columns "A" with the month(Jan-Dec), column "B" with the date (1-31), column "C" with numbers 1-7, and column "D" with an increasing value (1-100)

What i am trying to do is if Column B = 1(Date) and Column C=1 it will change column "D" to 1 or will continue with the increasing value. I already have the formula in "D" to increase the value (=D90+1)

Can anyone help please.

[6StringJazzer]

I would try this, if I understand you correctly. I assume the example formula you gave is in D91, and this would replace it:

=IF(AND(B91=1,C91=1),1,D90+1)

[Willows59]

I would try this, if I understand you correctly. I assume the example formula you gave is in D91, and this would replace it:

=IF(AND(B91=1,C91=1),1,D90+1)

Thanks Jeff that worked fine. on another sheet i have a similar issue but C91 is text(Breakfast). if i replace (C91=1) with (C91=Breakfast) it does not work and i get a #NAME? Error. is there a formula to do this also.

[AliGW]

Put the word breakfast into quotes - "breakfast".

[AliGW]

Thanks for the rep.