formula or conditional formating

  • Thread starter Thread starter James Beam
  • Start date Start date
J

James Beam

On worksheet 4, We need cell D6 to return the value of 5 if cell B4 on
worksheet 1 is between .01 and .50.



Is there a formula or conditional formatting for this ?



Thank you in advance.
 
Hi James!

Try:
=IF(AND('Worksheet 1'!B4>=0.01,'Worksheet 1'!B4<=0.5),5,"")

Note the use of ' for worksheets with spaces in their names.
Also not I've assumed >= and <= for your borders; you may need to
amend

Conditional formatting only affects how a cell appears. It doesn't
return a value.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top