Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
excel if statement help?
Hi i need help with if statement in excel, what I want to do is make an if statement fomula where calculates a discount of 5%, if the client spends more than 150
Can anyone please help me with this???
5 Answers
- Anonymous1 decade agoFavorite Answer
=if(address of cell>150,address of cell*150%,0)
- Digital_UtopiaLv 41 decade ago
IF (A1 > 150,(0.05 * A1),0)
Basically, if the value of A1 is greater than 150, the cell this function resides in will display a discount of 5% of the value of A1, otherwise, it will just display a zero.
- bokomokoLv 71 decade ago
Suppose the value spent is in A1 and you want the net value (with discount) in b1
Use the folowing formula
=if( a1 > 150 , a1*( 1 - 5%) , a1)
or ..
=a1 * ( 1 - if( a1 > 150 , 5% , 0 ) )
- 5 years ago
If the only possibilities are "yes" and "no", you should consider switching to TRUE and FALSE, which can be more directly calculated: AND(B2:F2) returns TRUE only when the entire range is also TRUE (or blank). OR(B2:F2) returns TRUE if at least one cell is TRUE. Scrawny and garbo's functions work fine if you must use "yes" or "no", or if there are other possibilities.
- How do you think about the answers? You can sign in to vote the answer.
- Anonymous1 decade ago
If cell A1 is how much the client spent, then you might try this:
=IF(A1 > 150,A1-(A1*0.05),A1)
