Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula Help
I need help, I have looked at the current if trreads but they are not working
for me I need an if formula to display yes in a cell if cell D20 =<280 I tried the formula below with different verations but the result is an error everytime. Please help =IF(D20=<280),"YES","NO" -- starkeyr |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula Help
=IF(D20<=280,"YES","NO")
starkeyr wrote: I need help, I have looked at the current if trreads but they are not working for me I need an if formula to display yes in a cell if cell D20 =<280 I tried the formula below with different verations but the result is an error everytime. Please help =IF(D20=<280),"YES","NO" -- starkeyr -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formula Help
starkeyr wrote:
:: I need help, I have looked at the current if trreads but they are :: not working for me I need an if formula to display yes in a cell if :: cell D20 =<280 I tried the formula below with different verations :: but the result is an error everytime. Please help :: :: =IF(D20=<280),"YES","NO" :: -- :: starkeyr Close bracket should be at end of whole formula, NOT after '280! -- RiTSo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |