Hi
I'm having an issue getting a formula working. I believe it needs nested if statements to do it but I've not been able to after multiple attempts. I've added a full description of what is needed in the attached spread sheet.
Any help greatly greatly appreciated
Excel table.xlsx
!
Try, H4=IF(MIN(E4,$H$8-SUM(H$3:H3)-$D$8)<D4,0,MIN(E4,$H$8-SUM(H$3:H3)-$D$8)), copy down.
thanks for this Joseph unfortunately it doesnt quite do it what I seeking. It doesn't take into account column C the interest rate column. thanks again thoughOriginally Posted by josephteh
Your formula doesn't make much sense.
=IFS(
AND($H$8>$D$8,N5=LARGE($C$4:$C$8,1)),E5,
AND($H$8>$D$8,N5=LARGE($C$4:$C$8,2)),E5,
AND($H$8>$D$8,N5=LARGE($C$4:$C$8,3)),E5,
AND($H$8>$D$8,N5=LARGE($C$4:$C$8,4)),E5,
"True",G5)
If all fist 4 lines return the same result (E5) why bother asking?
Last line, what is true to return G5?
In my opinion you should go try a solver for this kind of question.
Last edited by DJunqueira; 02-04-2024 at 03:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks