Christine81
New Member
- Joined
- Nov 5, 2021
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
hi guys happy Friday, looking for some help please here is a chopped down screen shot of my data. I'm trying to work out the formula so that if the on hire date is this month delivery to be billed on first invoice returns the value in the delivery cell but if it is not the current month it returns zero value
also if the terminated/continuing says terminated i want collection to be billed on termination to return the collection value and if it says continuing for it to be blank
also if the terminated/continuing says terminated i want collection to be billed on termination to return the collection value and if it says continuing for it to be blank