Formula Question

[Atalkez]

Hello!

So, I have a spreadsheet with several columns that contain various information. I am trying to work out a formula that will check if a flag is set in two separate columns, then depending on a range of values in another column, determine a calculation for a final result.

So, in normal coding, it would be something like this:
if(C3 == "N") && (F3 == "Y") {
if (D3 > 200)
calculate and post
else
calculate and post
}
if (C3 == "N") && (F3 == "N") {
if (D3 > 200)
calculate and post
else
calculate and post
}

To make it a bit more clear, this is a commission calculation spreadsheet. The flag options are N/U for New/Used, and Y/N for Yes/No in regards to if the deal was split (which makes me divide by 2 obviously). The calculation is different for New/Used, and the split determines if the calculation needs to be divided or not.

This is what I have right now:

=IF(MATCH(N, C3, 1)), =IF(MATCH(Y, F3, 1)), =IF((D3*0.25)<200,"$190"), =IF((D3*0.25)>200, SUM(D3*0.25)))

This doesn't work, however, so if anyone can help clear up my mistakes in regards to the calculation, that would be very helpful

Thanks!

 

[Atalkez]

The formula you posted there didn't take into account the U/N to determine if I should divide by 2 - how should I incorporate that?

 

[Atalkez]

Ignore the previous post, I misread the formula. It seems to be working so far!