Im trying to have a budget table and see what credit cards are the best for my spending. I have a category section and a percentage section based on each cards cash back. I want to automate column E so that I can multiply column D and B based on category name instead of going one by one. Example for cell E2 should multiply 5% * B8 only if Column D and A match with the name (Gas). How can solve this?

Overall, trying to find the proper “If statement” for excel,

Use a set of “if statements” to calculate the percentage of possible points earned for multiple choice (MC) items and open response (OR) items for each student. Record your calculations in columns D and E.

I am writing a test on REDCAP where the user must enter 5 potential diagnoses based on the data provided. The user will be allowed to enter the answers in any order. When I export, the answers will be exported to excel, but each correct diagnosis must be placed into a specific cell. This is being done this way for grading ease (and potentially to incorporate this into REDCAP in the future for immediate user feedback).

=IF(DATEDIF(B3;TODAY();”d”)>10;DATEDIF(TODAY();B3;”d”);”Less than 10days”),
I want to check whether the event date and today date difference is more than 10days,if so then print the days if not then print its less than 10 days in excel..

Sorry for the bad English, i’m dutch.