Software

Ask something
Discussion Locked

Excel 2000 "IF" calculation

0 helpful
5 replies

by sr71crewchief

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to have excel diplsy a given number based on a given range i.e... if "X" number is greater than 10 but less than 24 then a certian number is always displayed. If this is possible what would the expression be?

5 replies

by tlg1025

=IF(Logical test, Value if True, Value if False)
=IF(AND(A1>=10, A1<=24),100, A1)
This says that if the value of cell A1 is greater than 10 AND less than 24 then enter the value 100. If not, then enter the value of cell A1.

This discussion is closed to new replies.