Multiple isnumber

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

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Formula 2
Sum totals 2
IF clause for a range of cells 3
General Calculator 1
revise CONCATENATE code 2
Why doesn't this nested IF statement work? 4
Scan 12 columns from right to left and return the first value that is not zero? 3
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. 1

Top