If statement for cell ranges to equivalent value

  • Thread starter Thread starter Rechie
  • Start date Start date
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
 

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
If statement for a range of cells 3
Use a value as a cell reference 1
Sumproduct and Count If 1
Formula to check two rows for equivalence 3
Conditional Formatting Minimim Value 2

Back
Top