Menu
Ask a question Report

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
Excel Ask a question Report
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

Report Respond to Mazzaropi
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.
Report Respond to Jam
Jam - Jan 3, 2017 at 04:29 PM
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%
Report
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!
Report
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
Report
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!
Ask a question