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.
Bookmarks