| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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 |
Threaded Mode
