IF Function Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If I am reading your post correctly you want a cell to equal C1/D1 when
A1=1
and B1= some some number
and for the cell to = "na" otherwise
=if(and(A1=1,B1=xx),C1/D1,"na")
Just enter your wanted number in place of xx or
you could put the number you want in E1 and use
=if(and(A1=1,B1=E!),C1/D1,"na")
If I am not reading your post correctly, please let me know.
in
 
thanks Michael. Another question:

Since there isn't an averageif, what is the best way to average a particular
set of numbers? Thanks.
 
You must log in or register to reply here.

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

How do I get a total 3
creating nested formulas from drop down box 5
IF Statement 3
Format of cell 1
Calculate numbers till 60 9
Format of cell 1
Different cells that need to sum in one 4
How to copy the function SUM but offseted in 7 columns 2

Back
Top