IF and IS TEXT or IS NOT Blank [Solved/Closed]

Jam - Jan 3, 2017 at 03:02 PM - Latest reply: ac3mark 9588 Posts Monday June 3, 2013Registration dateModeratorStatus June 21, 2018 Last seen
- Jan 5, 2017 at 05:17 PM
Hello,

Can somebody help me with this formula...I want the excel to display a computation, if A2 is a Seller, and A2 has a value, then compute Price X commission + bonus.
A2- Seller or Buyer
B3 - Price
C3 - Commission
D3 - Bonus.
See more 

5 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Jan 3, 2017 at 04:02 PM
0
Thank you
jam, Good evening.

It's a little confuse your explanation.

A2 has a Text or a Value?
You said it has a word "Seller" or "Buyer".

Please, give us an example and show us what is the desired result.
0
Thank you
Hi,http://ccm.net/forum/affich-952157-if-and-is-text-or-is-not-blank#
Thanks for the prompt reply on my inquiry. Here it is

Create the following formula for the Pend Buyer (column E):
If the Type (column A) is Buyer and the Price (column B) is not blank, then multiply column B times column C and then add column D.

If the Type (column A) is Seller and the Price (column B) is not blank, then multiply column B times column C.

A B C D E
Type Price Commission% Bonus Pending Buyer
Buyer 120,000 5% 200
Buyer 105,000 6% 200
Seller 240,000 6%
Seller 185,000 7%
ac3mark 9588 Posts Monday June 3, 2013Registration dateModeratorStatus June 21, 2018 Last seen - Jan 3, 2017 at 06:18 PM
pend buy =if(and(a1="buyer",b1<>""),B*C+D,"")
a1=buyer
b1=(price<>nothing/NA/NULL/blank)
Sorry to interrupt!
Jam > ac3mark 9588 Posts Monday June 3, 2013Registration dateModeratorStatus June 21, 2018 Last seen - Jan 5, 2017 at 04:42 PM
Hi ac3mark,

Oh my, Thank you so much!!!
I got it now.
I really appreciate your help and everyone here.

Share our Knowledge to Others Always, for it is already a Blessing!!!

Thank you,
Jam
ac3mark 9588 Posts Monday June 3, 2013Registration dateModeratorStatus June 21, 2018 Last seen - Jan 5, 2017 at 05:17 PM
Jam you are very welcome. I normally don't answer these as most reply back with a much larger scope than first explained. You are always welcome to come here for help, as long as you give us complete details, and you have tried it your self!