User Profile
RobbieD2020
Copper Contributor
Joined Jan 17, 2020
User Widgets
Recent Discussions
Re: Listing IF formulas
Thank you JKPieterse Yes, you seem to be right about IF($D22>=2,$D22<4,IF(. I'll need to look at that again. Essentially, I'm trying to say that if a number in a cell ($D22) is equal to or greater than 2 and less than 4, then....blah blah blah. That's clearly the wrong way to express it. However, the 1st and last IF commands in my string work individually but it is only when I separate them with a comma, to try and use them together, that I get the issue. I also agree that using fixed numbers in the string is not the "best way" but even so, it should work. I'm under time constraints on this and was hoping to cut a few corners.. I'll investigate VLOOKUP, thanks.1.8KViews0likes0CommentsRe: Listing IF formulas
Thank you mathetes Yes, as I was creating this string I was beginning to realise that it wasn't the best way to do things. But I'm going on hols on Monday and was hoping to make this work before then - its just a small part of what I need to complete so I was keen just to find out the particular issue in what I have done.1.8KViews0likes0CommentsListing IF formulas
I'm hoping someone out there can help..? I'm trying to list a number of IF formulas in one cell. If I do just the first one by itself, the formula works and I get the correct answer. However, when I start adding them into a list, each asking a different question, I get the dreaded #Value! It must be something to do with they way I am listing them i.e. separating with a coma, because, like I say, individually they each work. This is my formula below in the list - can someone please point out the obvious to me as I'm losing the will to live! =IF($D22<2,IF($C22=25,SUM($D22/(($BP22-56-245)*($BQ22-110-140)/1000000)),IF($C22=50,SUM($D22/(($BP22-106-245)*($BQ22-150-140)/1000000)),IF($C22=75,SUM($D22/(($BP22-106-245)*($BQ22-200-140)/1000000)))))), IF($D22>=2,$D22<4,IF($C22=25,SUM($D22/(($BP22-56-315)*($BQ22-110-140)/1000000)),IF($C22=50,SUM($D22/(($BP22-106-315)*($BQ22-150-140)/1000000)),IF($C22=75,SUM($D22/(($BP22-106-315)*($BQ22-200-140)/1000000)))))), IF($D22>=4,$D22<7,IF($C22=25,SUM($D22/(($BP22-56-385)*($BQ22-110-150)/1000000)),IF($C22=50,SUM($D22/(($BP22-106-385)*($BQ22-150-150)/1000000)),IF($C22=75,SUM($D22/(($BP22-106-385)*($BQ22-200-150)/1000000)))))), IF($D22>=7,IF($C22=25,SUM($D22/(($BP22-56-455)*($BQ22-110-150)/1000000)),IF($C22=50,SUM($D22/(($BP22-106-455)*($BQ22-150-150)/1000000)),IF($C22=75,SUM($D22/(($BP22-106-455)*($BQ22-200-150)/1000000))))))2.1KViews0likes10Comments
Recent Blog Articles
No content to show