Use IF, not IIF

IIF is for Access; IF is for Excel.

Dave
--
Brevity is the soul of wit.


"JoeA2006" wrote:

I am getting #Name? using this formula

=iif(O455<0,0,(IF(N4550,(P455*M455),0)),((N455*M4 55)-(O455*M455)))
I want to the cell to be 0 if the calculations are negative.
Thanks