If function with text

R

Richard

I posted a question about if function earlier, but here is the a new twist.
I want to use a function probably the if function to check if say from cell
A2 to E1 to see if the value is less than .5 or no data or equal to o, if
true than give cell F1 a value of 1, and if cell A1 has not text in it,
then, give cell F1 a blank or nothing. How do I write this function?
 

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

Top