IF Statement

  • Thread starter Thread starter Voodoodan
  • Start date Start date
V

Voodoodan

Hello!

I have 3 cells, say A1 to C1.

A1 = a reference number
B1 = containing If Statement
C1 = Name of person who has signed and returned a document


What I want to do is this...!

When A1 has data in it and C1 is blank, B1 will say, for instance,
'No'.

But, when A1 -and- C1 both have data in them then B1 will say 'Yes'.

I'd appreciate any help with that please. I think it's probably quite
easy to do but my head is on a low gas setting today!

Thanks,
Dan.
 
you could use

=IF(ISBLANK(A1),"",IF(ISBLANK(C1),"No","Yes"))
or
=IF(A1="","",IF(C1="","No","Yes"))

ope this helps
Mike
 
So if A1 is blank or C1 is blank (or both are blank) then b1= No
If A1 and C1 are both filled then B1 = Yes?

Try (in B1): =IF(OR(ISBLANK(A1),ISBLANK(C1)),"No","Yes")
 
In C1

=IF(B1="","No","Yes")

=IF(AND(A1<>"",B1<>""),"Yes","No")

the first one should be enough..
 
The first formula will not work since isblank returns false if there is a
formula in B1 (not C1)
returning blank and the OP stated that B1 had an IF formula
 
Hi,

Thanks for that, it works just how I asked.

However, I'm a donut!

I forgot to mention that if A1 should = "N/A" then b1 should also =
"N/A".

Is there any way to get that into the formula at all?

Sorry to be a pain in the rear.

Thanks,
Dan.
 
I'm using *=IF(ISBLANK(A1),"",IF(ISBLANK(C1),"No","Yes"))* at the
moment.

That formula is in cell B1 and currently shows "Yes" because both A1 +
C1 have data in them.

However, if A1 = "N/A" then I would like "N/A" to be shown in B1
instead of "Yes" or "No".

Thanks,
Dan.
 
Voodoodan said:
I'm using *=IF(ISBLANK(A1),"",IF(ISBLANK(C1),"No","Yes"))* at the
moment.

That formula is in cell B1 and currently shows "Yes" because both A1 +
C1 have data in them.

However, if A1 = "N/A" then I would like "N/A" to be shown in B1
instead of "Yes" or "No".

Thanks,
Dan.
Click to expand...

=IF(ISBLANK(A1),"",IF(ISNA(A1),NA(),IF(ISBLANK(C1),"No","Yes")))
 
Paul,

Thanks for the formula, however it doesn't appear to work for me.

The last part of the formula (where Yes or No is entered depending on
C1) seems to be overriding the rest of the formula.

Therefore it won't show N/A, but shows either Yes or No, because of the
last bit of the formula... I think!

I appreciate all the help I'm getting with this, so thanks very much.

Dan.
 
Back
Top