IF condition after the IF before is true ?

**karmapala** · 08-27-2019, 04:39 PM

The formula is in cell A4.

IF cell A1 value is found in range "Stock"
THEN put cell A2 with cell A1 value

IF (cell A2 with cell A1 value) is resulting/causing cell A3 a blank value
THEN have "Not Available" in cell A4.
ELSE
have "Available" in cell A4
END IF

ELSE
have "Not Available" in cell A4.
END IF

So far, I try like this :

Please Login or Register  to view this content.

which of course it doesn't work

.
For me, it turns out making a formula is much much much more difficult then writing a VBA

.

So, how do I write the formula ?

Any kind of help would be greatly appreciated.
Thank you in advanced.

**Sam Capricci** · 08-27-2019, 04:49 PM

is Stock a range (table name) or is Stock the value in cell A1? And you have stock spelled differently in your cell Stock vs Stok.

**Sam Capricci** · 08-27-2019, 04:52 PM

is this what you are wanting?...
=IF(AND(COUNTIF(B2:B10,A1)>0,A2=A1),"Not Available",IF(A3="","Not Available","Available"))
you can also add another item to the AND to make it this way and I think this would also work...
=IF(AND(COUNTIF(B2:B10,A1)>0,A2=A1,A3=""),"Not Available","Available")

I substituted B2 through B10 for what I am assuming is your named range of stock.

**karmapala** · 08-28-2019, 07:53 AM

Originally Posted by Sambo kid

is Stock a range (table name) or is Stock the value in cell A1? And you have stock spelled differently in your cell Stock vs Stok.

Hi Sambo kid,
The "Stock" is a named range.
I'm sorry as I mixed-up the word with my own language, that's why the formula in the block code read "Stok".

Thank you.

**Sam Capricci** · 08-28-2019, 08:11 AM

So, did either of those formulas solve your issue (when you substitute Stock for B2:B10)?

**karmapala** · 08-28-2019, 08:13 AM

Originally Posted by Sambo kid

is this what you are wanting?...
=IF(AND(COUNTIF(B2:B10,A1)>0,A2=A1),"Not Available",IF(A3="","Not Available","Available"))
you can also add another item to the AND to make it this way and I think this would also work...
=IF(AND(COUNTIF(B2:B10,A1)>0,A2=A1,A3=""),"Not Available","Available")

I substituted B2 through B10 for what I am assuming is your named range of stock.

Hi Sambo kid,
Thank you for the formula. But I'm sorry it still doesn't work.

The problem maybe is in my computer as even a simple condition like this :
Cell A1 contains a word "Squid".
Cell A2 is blank.

Cell A3, formula :

=IF(A1="Squid",A2=A1)

It doesn't fill cell A2 with a word "Squid".

I give up, as I will just use the VBA.
Anyway thank you for your help, Sambo.

**Sam Capricci** · 08-28-2019, 08:20 AM

well, if A1=squid, in that formula =IF(A1="Squid",A2=A1) it will return false.
if you want Squid in A2 if it is in A1 you'd want this in A2, =IF(A1="squid",A1,"")
A formula in A3 won't fill a value into A2. Yes, VBA would do that.

**karmapala** · 08-30-2019, 05:13 AM

Hi Sambo,
Thank you for your explanation. I just realize about that after you inform me.

IF condition after the IF before is true ?

LinkBack

Thread Tools

Rate This Thread

Display

IF condition after the IF before is true ?

Re: IF condition after the IF before is true ?

Re: IF condition after the IF before is true ?

Re: IF condition after the IF before is true ?

Re: IF condition after the IF before is true ?

Re: IF condition after the IF before is true ?

Re: IF condition after the IF before is true ?

Re: IF condition after the IF before is true ?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] how to get first value, when condition true.

Help popup window if condition is TRUE in change event if conditon is true

[SOLVED] Copy all row if condition is true

[SOLVED] subtract days between due date and todays date, if condition 1 and condition 2 are true

[SOLVED] How to sum cel if condition is true

open a comment to cell range upon true condition then removing comment on false condition

TRUE condition???

Bookmarks

Bookmarks

Posting Permissions