Nested if formula clashes

  • Thread starter Thread starter Guest
  • Start date Start date
=IF(AND(E5>600,E5<799),"Green", "Red")

This is better asked in the worksheet.functions group not programming.
best wishes
 
You must log in or register to reply here.

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

Looking for exam clashes in excel 0
Excel Assistance with Fomula 0
Clear contents of last two rows of data on sheet 6
Nested If / And Statement with Conditional Formatting. 2
Improving Nested Formula Calculation Efficiency 2
mileage cap using vlookup 2
what is the formula for what I want to do 1
paste values without copy-paste values 1

Back
Top