| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formula
I was hoping someone could show me how to compare two cells to populate a
third. something like this =if(A15(and(A2<20)), "moderate", "") reading if A1 is greater than 5 and A2 is less than 20, return the string moderate, else leave the cell blank. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formula
=IF(AND(A15,A2<20),"moderate","")
"Beans" wrote: I was hoping someone could show me how to compare two cells to populate a third. something like this =if(A15(and(A2<20)), "moderate", "") reading if A1 is greater than 5 and A2 is less than 20, return the string moderate, else leave the cell blank. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
| Conditional Formula to indicate Formula in cell | New Users to Excel | |||
| Conditional Sum Formula | Excel Discussion (Misc queries) | |||
| conditional sum formula | Excel Worksheet Functions | |||
| Conditional formula | Excel Worksheet Functions | |||
Linear Mode
