Function if ex: a1=2 then b1=text1 b2=text2

Dovys

New member
Joined
Apr 1, 2014
Messages
1
Reaction score
0
Points
0
Hi,
Is there any option make if function for adding text to another cell: if i got a1=1 then fill with custom text only b1, then i get a2=2 then fill b1=text1 and b2=text2 ect.?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Are you asking for a function that will put a value in one cell if condition A is met, but a different cell if condition B is met? If so, no can do, a function returns a value to the cell that it is used within.
 
Top