Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Getting a response other than true/false with an IF formula
I am having some trouble with this. I have this worksheet on loans. I have
to calculate a fee for each loan. ex: M1*.011=x. If x<100, it has to be changed to 100. If x225, it has to be changed to 225. If x is between 100 and 225, it stays that number. I'm trying to create an IF formula that will take the numbers <100 and change them to 100 and take those 225 and change them to 225, all the while keeping the numbers between 100 and 225 the same....any help? The only thing I've been able to create is a response of true or false, a response of only 100, or a response of only 225. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove false from formula response in cell | Excel Discussion (Misc queries) | |||
Changing Background Color as a True/False Response | Excel Discussion (Misc queries) | |||
True / False Formula | Excel Discussion (Misc queries) | |||
Formula True False help | Excel Worksheet Functions | |||
IF hypotheticals that are not TRUE/FALSE response | Excel Worksheet Functions |