-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
multiplication
-
L
Multiplying with zeros formula help!
Pretty new to excel so bear with me. Have to complete a table that responds to different values. I have a basic formula that is: =B18/B16*60 and i want it to be able to change in response to another cell and look like =(B18/B16*60)*B19. However I want B19 to be left as zero without making the...- lukeyry
- Thread
- help me multiplication noobie zero value
- Replies: 2
- Forum: Excel Questions
-
J
use If formula to match unit of measure and then multiply or divide
So here is my issue. i have items that our system looks at in basic units i.e. 100 bandaids in a box, 10 boxes in a case, etc. what i need to do is find out a way to figure out how many onhands we have of a PURCHASE UNIT. not necessarily in basic units and then multiply that by the purchase...- jnsturze
- Thread
- conversio multiplication n if formula
- Replies: 4
- Forum: Excel Questions
-
A
vector multiplication.
hi, i need help in knowing how to use an array formula for the following (and even help in knowing if i need an array formula!) i have my data in pairs like this: (ax1, by1),(cx2, dy2),... (im using the numbers 1,2,3... only as index to denote the pair, not as powers!) and in excel i have...- .ash.
- Thread
- multiplication pair vector
- Replies: 1
- Forum: Excel Questions
