Hello,
I am trying to write an if statement for example if the dollar amount is between $5.01 and 150, then * by 3.5 and I cannot seem to get the statement correct. Any help would be greatly appreciated.
Thank you
Hello,
I am trying to write an if statement for example if the dollar amount is between $5.01 and 150, then * by 3.5 and I cannot seem to get the statement correct. Any help would be greatly appreciated.
Thank you
Re: Creating If Statements
Assuming the dollar amount is in A1
=IF(AND(5.01<A1,A1<150),A1*3.5,A1)
should do it.
Re: Creating If Statements
The other part is getting this to work with the whole column and not just a single cell. Like The amount in column O and placing total in column P.
Re: Creating If Statements
So do you need to find all of the values in column O between 5 and 150 and multiply them by 3.5 and then sum just those? Your post is not very clear on what you need.
Re: Creating If Statements
To further respond to SETI, if didnt read the first part, taking column O for example and using the above if statement. Taking everything in column O and * by 3.5 for putting the results in column P if possible. Again, any help is greatly appreciated.
Re: Creating If Statements
I'm very sorry, but I can read your response in one of two ways. You could be trying to apply the IF statement to every value in column O, one cell at a time and putting the result in column P, cell by cell. In this case, if you were looking at cells O2:O10, you would get a result in each cell in P2:P10. If so, you would just create a formula in P2 and copy it down the rest of the column.
If instead, you just want one cell in column P to contain the sum of all cells in O where the value is between 5.01 and 150, you could use this in P2 maybe:
=SUMPRODUCT(--(O2:O10>5.01),--(O2:O10<150),3.5*O2:O10)
Don’t have an account yet? Register yourself now and be a part of our community!