mercredi 30 novembre 2016

Nested IF function in excel not working

I am trying to implement an IF function for a simple pricing database where if a cell is equal to one of 3 time durations, the cell automatically generates the correct price based on length of time. Here's what I have so far based on what other examples have of nested Excel functions:

=IF(F4=12;"$60";IF(F4=6;"$40";IF(F4=3,"$30")))

My primary issue is that the second condition has a red bracket, indicating an error. If I then swap the ";" for a ",", I have the same result.

As there are only 3 conditions, I have also tried the following:

=IF(F4=12;"$60",IF(F4=6;"$40","$30") 

But again I have the same issue with the bracket being red on the second condition.

Any ideas?

Aucun commentaire:

Enregistrer un commentaire