IF and IS TEXT or IS NOT Blank
Solved/Closed
Related:
- IF and IS TEXT or IS NOT Blank
- Conditional formatting if another cell is blank - Excel Forum
- Creator studio blank screen ✓ - Facebook Forum
- Why is my facebook page blank ✓ - Facebook Forum
- Select the disk where to install macos blank - Guide
- Macro copy and paste in next blank cell - Guide
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
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.
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.
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%
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%
