| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
formular
if 30<a1<40 after that write in a2 ,"no".what is formular
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formular
Hi
=IF(AND(A1=30,A1<=40),"No","Something else") Replace something else with what you want if the condition is not met. -- Regards Roger Govier "readmynote student" <readmynote wrote in message ... if 30<a1<40 after that write in a2 ,"no".what is formular |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formular
IF PLUS AND IS USEFUL FOR UNLIMITED LOGICAL FUNCTION BUT WITH JUST IF YOU
HAVE LIMITED.YOU CAN USE THIS IF(AND(30A1,A140),A1,"NO") "readmynote student" wrote: if 30<a1<40 after that write in a2 ,"no".what is formular |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I still need help with formular? | Excel Worksheet Functions | |||
| formular | Setting up and Configuration of Excel | |||
| Excel - What is ^ in a formular? ie +(p23)^.5 | Excel Discussion (Misc queries) | |||
| If formular | Excel Discussion (Misc queries) | |||
| Need Help With A Formular | New Users to Excel | |||
Linear Mode
