I am very frustrated with the syntax needed in Excel 2010 to perform a simple IF AND statement. The following formula works flawlessly if K4>0.
=IF(K4>0,(O27 + (E13/2) + E25),(O27 + (E13/2) + E25 + P2))
I need to add the logic to make the final result be 0 if K4 =0.
Any and all help will be greatly appreciated.