ExcelBanter - Multiple isnumber

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple isnumber (https://www.excelbanter.com/excel-worksheet-functions/222287-multiple-isnumber.html)

Steve[_16_]

Multiple isnumber

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.

Mike H

Multiple isnumber

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

"Steve" wrote:

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

All times are GMT +1. The time now is 03:50 AM.