How would I stop an IF function in excel that references the cell before it? It\

Question

How would I stop an IF function in excel that references the cell before it?

It's basically a draw schedule that categorizes the months by month number and at the end I want the "Total" column generate.

Here's the set up: (Assumptions C82 value is irrelevant - if it was 34, once month 34 is generated the next cell in the row should say "total")

A1: 1, B1: =IF(A1<'Assumptions'!$C$82, 'Schedule'!A1+1, "Total"), C1: =IF(B1<'Assumptions'!$C$82, 'Schedule'!B1+1, "Total"), D1: etc...

I am able to generate the total column once the month is equal to C82, but after the total is generated I can't figure out how to stop generating the total column. Would it be an IF ELSE formula? I'm not sure how to set this up.

Any advice would be appreciated. Let me know if you need more information.

Explanation / Answer

Use a nested IF

B1: =IF(A1<'Assumptions'!$C$82, 'Schedule'!A1+1, IF(A1='Assumptions'!$C$82,"Total",""))

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.