Thread
:
Need help on IF condition
View Single Post
#
2
Posted to microsoft.public.excel.programming
JE McGimpsey
external usenet poster
Posts: 4,624
Need help on IF condition
What happens between 4 and 4.5?
One way, if I understand you correctly:
=ROUND(A1,0) - 2
In article .com,
wrote:
I have been researching on if condition, but unable to get it work,
I have to write a IF comnditon for the folowing,
Dollars Points
$3.0 1
$4.0 2
$5.0 3
$6.0 4
$7.0 5
$8.0 6
$9.0 7
$10.0 8
If $ value is =3 then 1
if $ value is =3.5 and <4 then 2
iif $ value is =4.5 and <5 then 3
like wise,
If not possible with IF condition, please let me know for alternative
formule,
please help
Reply With Quote
JE McGimpsey
View Public Profile
Find all posts by JE McGimpsey