i was advised to repost explaining my dilema properly. here goes.

i have the following formulas that work perfectly seperatly

=MAX(0,(E28-D28-"0:45")*24-F28)

=IF(C28=$C$70,C28=$C$72),2,0)

but it is imperative that i get them to show there results in the same cell.

neither are used at the same time, only one result is required depending on what is needed.

i did try putting them together as follows but did not work

=MAX(0,(E28-D28-"0:45")*24-F28),IF(C28=$C$70,C28=$C$72),2,0)


formula required please.