Thread
:
=IF(D43=45*D43<=87,"5.00","0.00")
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Biff
external usenet poster
Posts: 1,688
=IF(D43=45*D43<=87,"5.00","0.00")
"Mike" wrote in message
...
I'm trying to get a formula to be between two numbers. Is my * my problem
=IF(D43=45*D43<=87,"5.00","0.00")
Try this:
=AND(D43=45,D43<=87)*5
Format as NUMBER 2 decimal places
Biff
Reply With Quote
Biff
View Public Profile
Find all posts by Biff
=IF(D43=45*D43<=87,"5.00","0.00")