i need the if function to work as follows:

if(d2<d3<d4,ae1+af1,ag1)<d3<d4,ae1+ad1,af1)

<d3<d4,ae1+af1,ag1)

if d2 is less than d3 and d3 is less than d4, if true then add ae1 to af1, if false then show the value from cell af1

it doesn't seem to work. what can i do to get the results i want?</d3<d4,ae1+af1,ag1)

</d3<d4,ae1+ad1,af1)

if(d2<d3<d4,ae1+af1,ag1)<d3<d4,ae1+ad1,af1)

<d3<d4,ae1+af1,ag1)

if d2 is less than d3 and d3 is less than d4, if true then add ae1 to af1, if false then show the value from cell af1

it doesn't seem to work. what can i do to get the results i want?</d3<d4,ae1+af1,ag1)

</d3<d4,ae1+ad1,af1)

Last edited: