passing of values

[kiki burgh]

hi! reaching out to you for quick guidance for formula based on the following premises:

1. determine if there is value in Column A

• if there is no amount, blank or zero (0.00), then it does not compute for Column C & returns zero (0.00)

• if there is an amount, then it computes for Column C & returns values based values in Column B

2. determine if values 0, 1, or above is in Column B (range in Columns E & F)

• if 0, then it returns a specific numeric value (i.e., 1,250.00) in Column C

• if 1, then it returns with a negative 50% of a specific numeric value (i.e., 1,250.00) in Column C

• if equal or greater than 2, then it returns a negative 100% of a specific numeric value (i.e., 1,250.00) in Column C

* please note that specific value is assigned & may change any time based on available allocation

sample table below (& attached):
A B C D E F G
1 Amount Kicker 1 Amount Error Value Comment
2 0.000 0.00 0.00 0 1,250.000 value in F1 is assigned & may change
3 0.000 2.00 -1,250.000 1 -50%
4 0.000 1.00 -625.000 1 < -100%
5 1,814.585 3.00 -1,250.000
6 935.550 0.00 1,250.000

appreciate it.