Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ISNUMBER | Excel Discussion (Misc queries) | |||
ISNUMBER | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions | |||
isnumber multiple criteria. | Excel Worksheet Functions | |||
ISNUMBER | Excel Worksheet Functions |