KCALDERON5894
New Member
- Joined
- Mar 3, 2014
- Messages
- 7
Help. I am getting "you've entered too many arguments for this function". Does anyone know how to add more? I am trying to use: =IF(C5<1000001,C15,IF(C5<2000001,C17,IF(C5<3000001,C18,C19,C20,C21))) for the $1.5M , $4M & $5M option but it won't let me add C16, C20 & C21 for column one.
<tbody>
</tbody>
B13 | C13 | |
A14 | Options | $1,000 |
A15 | $1,000,000 | $1,100 |
A16 | $1,500,000 | $1,265 |
A17 | $2,000,000 | $1,430 |
A18 | $2,500,000 | $1,640 |
A19 | $3,000,000 | $1,850 |
A20 | $4,000,000 | $2,250 |
A21 | $5,000,000 | $2,650 |
<tbody>
</tbody>