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

If statement for equivalent value of a range 4
If statement with vlookup link to multiple sheets 4
Excel formula, sum the value cell and if empty cell left blank 0
Conditional Formatting Minimim Value 2
Use a value as a cell reference 1
To execute a formula upto in a cell 3
Automatic Hide group of a columns based on cel value 5
If statement for a range of cells 3

Top