Multiple If Statement With Conditional Formatting

[hc9587]

Hi all,

Trying to come up with a document that allows me to track all of my tutoring sessions, and whether or not I've been paid.

Trying to create a formula that accomplishes three things.

Column A = Date
Column B = Time of Session
Column C = Client Name
Column D = Total $ Due
Column E = Total $ Collected
Column F = Status of Payment

In Column F I want three outputs: PAID, NOT PAID, or blank.

PAID = Column D matches Column E
NOT PAID = Column E is blank, or zero (open to whatever is easier)
Blank (No cell data) = If the entire row is empty.

Looking for a formula that will accomplish all, and auto fill as new data is entered.

Any help is GREATLY appreciated.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(D2="","",IF(D2=E2,"Paid","Not paid"))

 

[hc9587]

Wow, that was incredibly fast, thank you SO much.

Now a larger, probably more complicated question:

If I want to be able to automatically generate daily reports (basically just a sum of how much money I've earned each date), how could I execute that? I imagine it's some sort of VLookup table, but my recollection of how to pull that off from a class in college 13 years ago is faded...

I imagine this is a table that could live somewhere in columns H:J on the side of all of this data.

 

[Fluff]

You would use the sumifs function for that.

 

[hc9587]

How could I automatically populate each new date as they get entered so that it fills down in a table?

 

[Fluff]

Use a structured table. How to create a table in Excel

 

[hc9587]

If I have 8 rows of data with 8/2/21
and 5 rows of data with 8/3/21

What would I put for the formula to aggregate/sum up all of the entries per unique date?

 

[Fluff]

You would use the sumifs function.

 

[hc9587]

I'm sorry for my lack of expertise on the matter, but what would come after =sumifs(

 

[Fluff]

Have a look here How to use the Excel SUMIFS function | Exceljet