heleneshere
New member
- Joined
- Jan 7, 2015
- Messages
- 5
- Reaction score
- 0
- Points
- 0
Hi Everyone!
I need your help please. I have 6,900,000 budget. I need to compute for (budget less cost). Do we have formula that can compute the amount, only if I provided the date. The B4 (33000) will subtract to B1 (6,900,000) only if I put a date on supposedly C4?
Please help with the formula. Thanks in advance!
A1:Budget B1:6,900,000
I need your help please. I have 6,900,000 budget. I need to compute for (budget less cost). Do we have formula that can compute the amount, only if I provided the date. The B4 (33000) will subtract to B1 (6,900,000) only if I put a date on supposedly C4?
Please help with the formula. Thanks in advance!
A1:Budget B1:6,900,000
A2: Course | B2:Cost | C2: Date |
A3: Social | B3: 5000 | C3: 10-Mar-15 |
A4:Gathering | B4: 33000 |