ExcelBanter - formula

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

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

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

jjackson

formula

what would the formula be for b2 to=1 if b1 is less than 6, and b2 to=2 if b1
is 6 or greater

Bernard Liengme

formula

=IF(B1<6,1,2)
OR
=1+(B1=6)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jjackson" wrote in message
...
what would the formula be for b2 to=1 if b1 is less than 6, and b2 to=2 if
b1
is 6 or greater

All times are GMT +1. The time now is 08:55 AM.