ExcelBanter - conditional formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formula (https://www.excelbanter.com/excel-discussion-misc-queries/148872-conditional-formula.html)

Beans

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

Toppers

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

All times are GMT +1. The time now is 08:49 PM.