Menu

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

Report
-
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 -
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

6 replies

Answer 1 / 6
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
 131
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.
Answer 2 / 6

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%
Report
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1576
pend buy =if(and(a1="buyer",b1<>""),B*C+D,"")
a1=buyer
b1=(price<>nothing/NA/NULL/blank)
Sorry to interrupt!
Report
> ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
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
Report
ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1576
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!
Ask a question