Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula questions
I am trying to write a formula that checks the number in cell B4 and if it is
between 1 and 52 then "A" would be placed in cell B6 but if the number was greater thatn 52 but less than 99 then "B" would be placed in cell B6 ect. Where do I start. What fomula should I use. Thank you for your help |
#2
|
|||
|
|||
In B6: =IF(AND(B41,B4<=52),"A"),B4<99,"B",""))
-- HTH RP (remove nothere from the email address if mailing direct) "Bob L" wrote in message ... I am trying to write a formula that checks the number in cell B4 and if it is between 1 and 52 then "A" would be placed in cell B6 but if the number was greater thatn 52 but less than 99 then "B" would be placed in cell B6 ect. Where do I start. What fomula should I use. Thank you for your help |
#3
|
|||
|
|||
Thank you Bob for the quick answer. That is exactly what I was looking for.
"Bob Phillips" wrote: In B6: =IF(AND(B41,B4<=52),"A"),B4<99,"B","")) -- HTH RP (remove nothere from the email address if mailing direct) "Bob L" wrote in message ... I am trying to write a formula that checks the number in cell B4 and if it is between 1 and 52 then "A" would be placed in cell B6 but if the number was greater thatn 52 but less than 99 then "B" would be placed in cell B6 ect. Where do I start. What fomula should I use. Thank you for your help |
#4
|
|||
|
|||
Bob,
I get an error when using this formula. Could you please check, as I it's above my head. "Bob Phillips" wrote: In B6: =IF(AND(B41,B4<=52),"A"),B4<99,"B","")) -- HTH RP (remove nothere from the email address if mailing direct) "Bob L" wrote in message ... I am trying to write a formula that checks the number in cell B4 and if it is between 1 and 52 then "A" would be placed in cell B6 but if the number was greater thatn 52 but less than 99 then "B" would be placed in cell B6 ect. Where do I start. What fomula should I use. Thank you for your help |
#5
|
|||
|
|||
Sorry, my error
=IF(AND(B41,B4<=52),"A",IF(B4<99,"B","")) -- HTH RP (remove nothere from the email address if mailing direct) "Bob L" wrote in message ... Bob, I get an error when using this formula. Could you please check, as I it's above my head. "Bob Phillips" wrote: In B6: =IF(AND(B41,B4<=52),"A"),B4<99,"B","")) -- HTH RP (remove nothere from the email address if mailing direct) "Bob L" wrote in message ... I am trying to write a formula that checks the number in cell B4 and if it is between 1 and 52 then "A" would be placed in cell B6 but if the number was greater thatn 52 but less than 99 then "B" would be placed in cell B6 ect. Where do I start. What fomula should I use. Thank you for your help |
#6
|
|||
|
|||
Thank you again
"Bob Phillips" wrote: Sorry, my error =IF(AND(B41,B4<=52),"A",IF(B4<99,"B","")) -- HTH RP (remove nothere from the email address if mailing direct) "Bob L" wrote in message ... Bob, I get an error when using this formula. Could you please check, as I it's above my head. "Bob Phillips" wrote: In B6: =IF(AND(B41,B4<=52),"A"),B4<99,"B","")) -- HTH RP (remove nothere from the email address if mailing direct) "Bob L" wrote in message ... I am trying to write a formula that checks the number in cell B4 and if it is between 1 and 52 then "A" would be placed in cell B6 but if the number was greater thatn 52 but less than 99 then "B" would be placed in cell B6 ect. Where do I start. What fomula should I use. Thank you for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
dragging a formula | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions |