I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
if A1 is "b" then C1 would be 5.
I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
if A1 is "b" then C1 would be 5.
Enter this formula in Cell C1:Originally Posted by Karen
=if(A1="a",3,if(A1="b",5,""))
NOTE: for any other entry in Cell A1, Cell C1 will be blank.
Regards.
BenjieLop
Houston, TX
=IF(A1="a",3,IF(A1="b",5,"Whatever you want if neither are true"))
"Karen" wrote:
> I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
> if A1 is "b" then C1 would be 5.
Put this in C1:
=IF(A1="a",3,IF(A1="b","5",""))
In article <[email protected]>,
"Karen" <[email protected]> wrote:
> I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
> if A1 is "b" then C1 would be 5.
Thank you so much!!
"Search33" wrote:
> =IF(A1="a",3,IF(A1="b",5,"Whatever you want if neither are true"))
>
> "Karen" wrote:
>
> > I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3 and
> > if A1 is "b" then C1 would be 5.
To return a zero when criteria is not met, try:
=(A1="A")*3+(A1="B")*5
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"Karen" <[email protected]> wrote in message
news:[email protected]...
I'm wanting to set a formula so that if cell A1 is "a" then C1 would be 3
and
if A1 is "b" then C1 would be 5.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks