If statement for cell ranges to equivalent value

R

Rechie

Hi,

Formula to get a equivalent of fixed value.

Formula to type in A1:
If range A2:A10=non blank (numeric value),
then A1=20.

Appreciate your time and help.

Rechie
 
R

Rechie

Hi Jacob,

This is it, Thanks a lot for helping me and the rest.

More power!

Rechie
 

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

VBA Coding Help for Beginner 0
If statement for equivalent value of a range 4
If statement with vlookup link to multiple sheets 4
Search cell value in same column 3
IF Statement accepting only positive values 1
If statement for a range of cells 3
Formula fill series? 1
Using Drop Down list to an If Statement to another Drop Down list 3

Top