if function help

lrkfam

New Member
Joined
Aug 18, 2011
Messages
4
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)
 
Last edited:

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,139
i need the if function to work as follows:


if(d2<D3<D4,AE1+AF1,AG1)<D3<D4,AE1+AD1,AF1)< p>
<D3<D4,AE1+AF1,AG1)< p>

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)< p>

Not sure whether your specifications are complete. Does the following...

=IF(AND(COUNT(D2:D4)=3, D2 < D3, D3 < D4), SUM(AE1:AF1), AF1)

works for you?
</D3<D4,AE1+AD1,AF1)[ p QUOTE]<>
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
i need the if function to work as follows:


if(d2<D3<D4,AE1+AF1,AG1)<D3<D4,AE1+AD1,AF1)< p>
<D3<D4,AE1+AF1,AG1)< p>

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)< p>
</D3<D4,AE1+AD1,AF1)[ p QUOTE]<>Maybe this...

=IF(AND(D2 < D3, D3 < D4),AE1+AF1,AF1)<D3,D3<D4),AE1+AF1,AF1)< p>
 

lrkfam

New Member
Joined
Aug 18, 2011
Messages
4
=IF(AND(D2 < D3, D3 < D4),AJ2+AE2,AK2)

i tried this one, but i get the same result as before using:

=if(d2<d3<d4,aj2+ae2,ak2)

i'm trying the other one now
 

lrkfam

New Member
Joined
Aug 18, 2011
Messages
4
ok. i think i got it to work now. not sure what the problem was before.

=IF(AND(D3 < D4, D4 < D5),AJ2-AE2,AK2)

seems to work perfectly for now. thanx!!!:biggrin:
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
ok. i think i got it to work now. not sure what the problem was before.

=IF(AND(D3 < D4, D4 < D5),AJ2-AE2,AK2)

seems to work perfectly for now. thanx!!!:biggrin:
You're welcome. Thanks for the feedback! :cool:
 

Forum statistics

Threads
1,086,120
Messages
5,387,961
Members
402,090
Latest member
thomastsiakis

Some videos you may like

This Week's Hot Topics

Top