#1
|
|||
|
|||
If A1 greater than or equal to 1 Then A3 = A2*A1
I need to know how to format a cell so that if for example:
If A1 greater than or equal to 1 Then A3 = A2*# from A1 Basically I have: A1 Qty A2 Cost A3 Total If A1 (qty) is greater or less than 1 Then A3 (total) needs to = A1 (qty) x A2 (cost) Any help would be great. I know basics but conditional formatting is a little beyond me. |
#2
|
|||
|
|||
Hi,
I have some questions to fully understand what you want. You write about "format a cell" (= red, bold, etc) but you never write when and what you would like to format (and how you like to format it). Some more questions: 1a) You write: A1 greater than or equal to 1 Then A3 = A2*# from A1 1b) I interpret: If the value in cell A1 is greater than or equal to 1 (example: 1, 2, 3, 4 etc) Then A3 = A2*A1 ("# from A1" I interpret as you mean the content in cell A1). 2a) You write: If A1 (qty) is greater or less than 1 Then A3 (total) needs to = A1 (qty) x A2 (cost) 2b) I interpret: If the value in cell A1 (qty) is greater or less than 1 (example: -5, -4, -3, 0, 2, 3, 4, but NOT "1") Then A3 = A1 * A2 (same as above!!!?!) Please clarify and I try to help you! Some examples might also help! Kind regards Bjorn |
#3
|
|||
|
|||
Imagine 3 columns. Cell A1 reads the quantity, Cell B1 reads the Cost and cell C1 reads the Total. Cell A2 has a number 1 in it. Cell B2 has $10.00 in it and Cell C2 should then have $10.00 in it. If I change Cell A2 (the quantity) to 8, then Cell C2 should change to $80.00. Conversely if have Cell A2 be 1, Cell B2 to read $20.00 Cell C2 should be $20.00.
A B C 1 1 $10 10 A B C 1 2 $10 20 A B C 1 8 $15 120 I hope this clears it up. |
#4
|
|||
|
|||
Hi again,
I am still i little unsure if I got you completely. See the attached file, with some very simple formulas. At what situation does this not work for you? Will you (manually) only change the values in cell A2 and B2? Kind regards Bjorn |
#5
|
|||
|
|||
that does almost exactly what I would like it to do. The only thing I would like is that if the Qty = 0, then Total is blank (ie doesn't show the "0"). its that part that is kind of screwing me up.
And sorry, I didn't see that I could attach a file, that would have made it much easier from the beginning. |
#6
|
|||
|
|||
Hi,
the reason to why your "zero" shows up as a blank, is probably a setting in your Excel. If you type a zero in a completely empty (new) sheet and still gets a blank here is what to do: Tools, Alternatives, View tab, click the "Zero values" check box, or look here: http://office.microsoft.com/en-us/ex...998791033.aspx Kind regards Bjorn |
|