Formula

Y

Yitzhack

Hi. This may be something simple but I’m not sure how to do it. I need a
formula where when value is greater than 5 but less than 8 = 0.5 and when is
greater than 0 but less than 5 = 1 at the same time all the data is
accumulating the points in cell A1. Thanks for the help in advance
 

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

Formula 9
Excel Need Countifs Formula Help 0
Excel Conditioning Formatting 3
Nested IF / greater than / less than help 5
Help, help! desparate for formula help!! 3
Formula needed changing font color 1
convert spreadsheet formula into VBA formula 1
Function to calculate dates 2

Top