0

How can I merge these two formulas in one cell?

= IF(D2="TRUE",C2+C2*20%, C2)

= IF(E2="TRUE",C2+30000, C2)

I have created two dropdown menu in excel, but can't merge them together.

I have tried to use this = IF(E2="TRUE",C2+30000, C2, IF(E2="TRUE",C2+30000, C2)), but it didn't work. Error:

you have entered too many arguments for this function.

Screenshot

2
  • =IF(D2="TRUE",C2+C2*20%, IF(E2="TRUE",C2+30000, C2)) Dec 8, 2020 at 22:32
  • Thank you, Scott. Dec 9, 2020 at 11:08

1 Answer 1

0

=IF(D2="TRUE",C2+C2*20%, IF(E2="TRUE",C2+30000, C2))

Answered by @ScottCraner in the comments.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .