Well, might as well try to get some useful stuff done while waiting for the update. I have a Spreadsheet in Numbers, that looks like this:
It is used to take any amount of money in a specific currency and convert it to dollars, like this:
B5 would contain the number - like 9886 Philippine Pesos, but only 9886 would be in the cell.
C5 contains a code for the currency, such as “P” for the Philippines (I have one column for each currency)
F4 holds the conversion value. It is based on how many Philippine Pesos are equal to $100 in U.S. dollars.
So the formula takes the foreign currency number and by multiplying 100 (the dollar reference I’m using), it divides it by the conversion value for that currency. So if I enter 9886 for Philippines Pesos, it divides $100 dollar base I’m using by 4943 and multiplies the result by the value I entered (9886) - which will result in the value of those Pesos in U.S. dollars ($200 in this case). Okay, all this works just fine, but I wanted to add something to it and, while it shouldn’t be hard, I’m just getting confused with all the “If” stuff!
That I want to add in column D (D5 to start), is a code to tell me it is a special case where 30% will be removed. So if this is the case, I’ll put an “S” in that cell. If it is not the case, I’ll leave it blank.
So, I need help adding this aspect to my formula above if anyone can help me. In short, if the S is there, I want the value of my original formula to multiply the result by 0.7 and if the S is not there, it leaves it as is.
One other thing. In order to make it easier to change these codes later, the “S” code will actually be permanently in cell D3 (thus I can just change that code if I want without affecting the formula).
So it is just like my currency codes I’d enter in column C that also reference the codes I have all across row 3.