Hi all,
I'm so new in excel scripting and i need simple help.
I've got a sheet with the following info.
Price - Bulk Price - Total price
And i need to calculate the total price (totalprice = (PRICE OR bulkPRICE * 2.5)
If Bulkprice contains a number i need to use that field but if it's empty i need to use Price.
How can i do this?
Try this
=IF(B2,B2*2.5,A2*2.5)
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
G'day Eric,
Price=A20, Bulk Price=B20, Total Price=C20
Try this,
Please Login or Register to view this content.
HTH
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
It didn't workit gave an error on the first argument
Does your version of XL support commas in formulas or semi-colons?
How can i find out if it can? i use office 2003! (dutch)
I thought as much ,seeing your name
Just replace the , with ; in the formula.That should do I think
Tobad that didn't work? can someone create a sample sheet for me? so i can test? :D
What error are you getting?Originally Posted by EricBruggema
Why don't you create a sheet so we can see your layout and your expected results.
Here is an example.
You see in the sheet what i need to know
The formula placed in Column D works fine for me.
=IF(C2,C2*2.5,B2*2.5)
I can't check arthurbr's comments on the Dutch version, but I am sure that is correct.
Hi and thanx!
This is the fix
=ALS(C2;C2*2,5;B2*2,5)
Darn, didn't think of the translation ...
Another question,
Is it possible to to only the math when the value is bigger then 0?
Anyone please? :D
G'day Eric,
Try this,
=ALS(C2=0;"";ALS(C2;C2*2,5;B2*2,5))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks