ifand

Hello, I am trying to write a formula that will perform the following function, and drag down a column: IF the value in column K is <0, the value in the same row of column I is the equivalent positive. The values in column I remain as a maximum. This is an example of the result I'm looking...

Hello all... I'm trying to write a nested IF(AND statement. Below is as far as I've gotten: =IF(AND(Order_Qty>1,Order_Qty<1000),Fixed_Order_Cost_Less_Than_1k*Order_Qty,0) When I try to add a second or third nest, I receive an error. Below is an example of a formula that fails...

GOOD AFTERNOON, I HAVE STRUGGLED ENOUGH TRYING THIS NOW ITS TIME TO ASK THE GURUS. WORKING WITH 2 COLUMNS: F WILL ONLY CONTAIN 0 OR 1 H WILL ONLY CONTAIN YES OR NO SHOULD IT BE IF AND OR? PLEASE HELP...

I want to consolidate my IF(AND formula and am having issues. Even though this is messy, it does work for my needs...

Is it possible to put more than one range in an IF(AND( function. For example: IF(AND(A27>=1,A27<=3),A27*5),IF(AND(A27>=4,a27<=6)A27*6) Is there a way I can do this? Because excel doesn't allow me to.

Hello People, This is my first post on MrExcel.com - apologies for not posting an introduction and diving straight into the issue I'm having with my Excel Formula. Basically, I have a tape storage record which I record all backup tape information. I have added an additional column called...

Hello - Problem: I am trying to get a formula to display the letter "G", "D", or "GI" based on the values of two other cells. Example: Symbol G,D,GI % Yes/No A G 0.25% Y B...

Hello, I have searched everywhere and cannot find how to solve this. I have a table that looks like: A_B_C_D_E_F 1 1 1 10 123 10 ? 2 1 1 20 636 3 2 1 30 257 4 2 1 10 563 .... this goes on for...

Hello, I have seen this answered before, however I have not been able to get the function to work correctly for me. I really appreciate any help that can be given and apologize if this is too similar to something else. I am looking for a formula that will look between ranges to return a value...

I have been playing with If(and( statements trying to get it to work but I guess I just am not sure how to get it to work in this scenario. I have a percentage result in M2, N2 and O2. I am trying to see if all three values are individually over 95% and if so, I want to enter "Review", if not "".

How do I make the form if: X = 1-50 then 81 X = 51-100 then 108 X = 101-200 then 158 I can only do the first one :( Please help. //: Dan

Excel 2010 Right now, I am working on a table that is going to count the amount of each part purchased. Then, I want to have a cell that will check which cell is highest, and report a cell that is adjacent to the highest one. It sounds complicated, but the picture should make it make sense...

Already Found it

Hey there! I am trying to set up a macro in my schedule worksheet for a summer camp. I want to be able to update the "By Activity" sheet with initials for each of the cabins (i.e. OG=Orange Girls) and it automatically search for and populate those fields in other areas of the spreadsheet. Can...

Hi Everyone, I have a really frustrating issue with what should be a simple formula. I want to say that IF C12 is greater than or equal too 100 and less than 2500 = Name 1 IF C12 is greater than or equal too 2500 and less than 5000 = Name 2 If C12 is greater than or equal too 5000 equal Name...

Hi all, Hope you all are fin and doing well I don't know if any such post is already there as I searched and couldn't find the desired match. The first column is "CE" , second "CG" third "CH" Firstly I want the date and time in both "CE & CG" get seprated in any other column. I want to...