Logical Functions

  • Thread starter Thread starter pjfatboy
  • Start date Start date
P

pjfatboy

Could someone help me with this formula?
What I want to do is, lets say if cell B3 is empty I want cell B10 to
show what is in cell B5, but if cell B3 is not empty I want cell B10 to
show what is in cell B3. I know this isn't right but maybe this will
help show what I am trying to do.....

IF(B3=" " Then B10=B5) else
IF(B3>" " Then B10=B3)

Thanks for any help!
 
In cell B10, enter this formula

=IF(B3="",B5,B3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
One way:

in cell B10, put

=IF(B3="",B5,B3)

or, if there might be a space character in B3:

=IF(TRIM(B3)="",B5,B3)
 
Back
Top