Multiple isnumber

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am trying to enter a formula based upon the value of 3 separate
cells being a number. If the value of J8, N8, and P8 are all numbers,
then I want (N8*(J8*32.39+P8)*0.07) to calculate, otherwise return a
0.

Thanks...
 
Steve,

Like this but I'll leave you to decide if the precedence of your formula is
correct.

=IF(COUNT(J8,N8,P8)=3,N8*(J8*32.39+P8)*0.07,0)

Mike
 
Back
Top