If function

[PaulD1984]

Good morning everyone,

I am a beginner to excel formulas and I am creating a holiday entitlement calculator for work. For the final calculation I need some criteria to be met for the outcome and I am not sure how to code this within excel.

Basically if the figure in cell V10 is lower than the figure in cell L10 I would like the outcome in cell W10 to be the figure in cell L10. If the figure in cell V10 is higher than the figure in L10 I would like the outcome in cell W10 to be the figure in cell V10, I hope this makes sense.

Any assistance warmly received and thank you in advance.

 

[AlanY]

what if V10= L10?

 

[fadee2]

hi @PaulD1984 ,
Welcome to the board.

try using below formula in cell W10

=IF(V10<L10,L10,V10)

 

[PaulD1984]

If V10 = L10 then no change needs to happen, either will be correct so probably just keep it at L10

 

[mohadin]

Hi
Simply

=IF(V10>L10,L10,V10)

 

[AlanY]

or

=min(L10,V10)

 

[fadee2]

Including your third condition the formula will look something like

If V10 = L10 then no change needs to happen, either will be correct so probably just keep it at L10

=IF(V10<L10,L10,IF(V10>L10,V10,IF(V10=L10,L10)))

hth

 

[PaulD1984]

Including your third condition the formula will look something like

=IF(V10<L10,L10,IF(V10>L10,V10,IF(V10=L10,L10)))

hth

Thank you so much, that's so helpful

 

[fadee2]

you are welcome....