Any help on writing this would be greatly appreciated
I would like a formula that would read something like:
If c1:c7 equals zero (no missed days of work)
And c9 is equal to or more than 650 (minimum dollars earned on a certain day)
Then d12 will equal c10 times point five ( c10 bonus earned based on the bonus percentage)
i have tried it in an "if," "sumif", "sumifs", and an "if & and" formula without luck. totally scratching my head
Add new comment