Report

IF and IS TEXT or IS NOT Blank [Solved]

Ask a question Jam - Last answered on Jan 5, 2017 at 05:17 PM by ac3mark
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.
Helpful
+0
plus moins
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.
Leave a comment
Helpful
+0
plus moins
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 8017Posts Monday June 3, 2013Registration date ModeratorStatus October 20, 2017 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!
Reply
Jam- 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
Reply
ac3mark 8017Posts Monday June 3, 2013Registration date ModeratorStatus October 20, 2017 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!
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!