ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF Formula Help (https://www.excelbanter.com/excel-worksheet-functions/128074-if-formula-help.html)

starkeyr

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

Dave Peterson

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

RiTSo

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




All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com