View Single Post
  #1   Report Post  
Michael
 
Posts: n/a
Default IF Function Help

Hi Flutie99
Try: =IF(A1=1,IF(ISNUMBER(B1)=TRUE,C1/D1,"na"))
--
Sincerely, Michael Colvin


"Flutie99" wrote:

How do I write a command that says:

=if(a1=1&b1=a number, c1/d1,"na")

How do I write the "a number" part?