Hi all...
I am looking for a formula which calculates dependent upon the rest of the columns. Here's what the headers in the spreadsheet looks like:
1st|Mth|2nd|Int|Hit|A/B|Bar|Low|High|Kill|Amt|Saved
If under "Bar" TO is typed then "Amt" is equal to "Saved"
If under "Bar" ANN is typed then set Saved to *
If under "A/B", A is typed and in Bar "KRO" is typed then Saved equals to the absolute ("High" - "Hit")*(Amt)/(High)
If under "A/B", B is typed and in Bar "KRO" is typed then Saved equals to the absolute ("Low" - "Hit")*(Amt)/(Low)
I would really appreciate any help. And I hope the above makes sense!
Many Thanks in advance, Ben
I am looking for a formula which calculates dependent upon the rest of the columns. Here's what the headers in the spreadsheet looks like:
1st|Mth|2nd|Int|Hit|A/B|Bar|Low|High|Kill|Amt|Saved
If under "Bar" TO is typed then "Amt" is equal to "Saved"
If under "Bar" ANN is typed then set Saved to *
If under "A/B", A is typed and in Bar "KRO" is typed then Saved equals to the absolute ("High" - "Hit")*(Amt)/(High)
If under "A/B", B is typed and in Bar "KRO" is typed then Saved equals to the absolute ("Low" - "Hit")*(Amt)/(Low)
I would really appreciate any help. And I hope the above makes sense!
Many Thanks in advance, Ben