Combining two IF/AND statements in the same formula

[Godot60]

Hello,

I have two IF/AND statements that need to be combined into the same cell. Each statement works separately but I cant seem to figure out a way to combine them. Suggestions welcome. Thanks.

=IF(AND(R19 < g19,l17="hourly"),(g19 2080),(g19="" 26))

=IF(AND(R19 > G19,L17="Hourly"),(R19/2080),(R19/26))

​

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...o-if-statements-same-formula.html#post5094007

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.