IF and IS TEXT or IS NOT Blank

Jam - Jan 3, 2017 at 03:02 PM
 Blocked Profile - Jan 5, 2017 at 05:17 PM

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.

2 replies

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
Jan 3, 2017 at 04:02 PM
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.
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.

Type Price Commission% Bonus Pending Buyer
Buyer 120,000 5% 200
Buyer 105,000 6% 200
Seller 240,000 6%
Seller 185,000 7%
pend buy =if(and(a1="buyer",b1<>""),B*C+D,"")
Sorry to interrupt!
Jam > Blocked Profile
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,
Blocked Profile
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!