Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Ugh!
Hi there, First time poster - please bear with me...
Here is what i am trying to do: Market rent = 1200.00 Current rent = 1170.00. I want to have a formula that takes the current rent, adds 3% if below market rent without going over market rent. If the sum of current rent+3% is over market rent then it calculates at 2.5% or brings the current rent to market rent unless it is equal to more than 3%. Here is the formula I'm using =IF(G50<F50,ROUNDUP(G50*0.03,2)+G50) ?????(G50F50,ROUNDUP(G50*0.025,2)+G50) Not sure how to do this (??? unknown transition) Thanks in advance for any help you can give! Bryan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Ugh!
Hi Bryan
With Market Rent in A1, Current Rent in B1 =MIN(A1,B1*1.03) -- Regards Roger Govier "Bryan" wrote in message ... Hi there, First time poster - please bear with me... Here is what i am trying to do: Market rent = 1200.00 Current rent = 1170.00. I want to have a formula that takes the current rent, adds 3% if below market rent without going over market rent. If the sum of current rent+3% is over market rent then it calculates at 2.5% or brings the current rent to market rent unless it is equal to more than 3%. Here is the formula I'm using =IF(G50<F50,ROUNDUP(G50*0.03,2)+G50) ?????(G50F50,ROUNDUP(G50*0.025,2)+G50) Not sure how to do this (??? unknown transition) Thanks in advance for any help you can give! Bryan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Ugh!
Try something like this:
With these values in cells A1:C2 Market Current PctIncr 1200 1170 3% D1: NewRent D2: =MIN(B2*(1+C2),A2) That formula returns the lesser of CurrentRent+3% or Market Rent Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Bryan" wrote: Hi there, First time poster - please bear with me... Here is what i am trying to do: Market rent = 1200.00 Current rent = 1170.00. I want to have a formula that takes the current rent, adds 3% if below market rent without going over market rent. If the sum of current rent+3% is over market rent then it calculates at 2.5% or brings the current rent to market rent unless it is equal to more than 3%. Here is the formula I'm using =IF(G50<F50,ROUNDUP(G50*0.03,2)+G50) ?????(G50F50,ROUNDUP(G50*0.025,2)+G50) Not sure how to do this (??? unknown transition) Thanks in advance for any help you can give! Bryan |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Ugh!
I'm also a bit confused about what you are trying to do but see if this
helps. =MIN(G9*1.03,G9*1.025) -- Don Guillett SalesAid Software "Bryan" wrote in message ... Hi there, First time poster - please bear with me... Here is what i am trying to do: Market rent = 1200.00 Current rent = 1170.00. I want to have a formula that takes the current rent, adds 3% if below market rent without going over market rent. If the sum of current rent+3% is over market rent then it calculates at 2.5% or brings the current rent to market rent unless it is equal to more than 3%. Here is the formula I'm using =IF(G50<F50,ROUNDUP(G50*0.03,2)+G50) ?????(G50F50,ROUNDUP(G50*0.025,2)+G50) Not sure how to do this (??? unknown transition) Thanks in advance for any help you can give! Bryan |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Ugh!
Awesome! Thank you so much.l That was much easier than what i had for a
formula! "Ron Coderre" wrote: Try something like this: With these values in cells A1:C2 Market Current PctIncr 1200 1170 3% D1: NewRent D2: =MIN(B2*(1+C2),A2) That formula returns the lesser of CurrentRent+3% or Market Rent Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Bryan" wrote: Hi there, First time poster - please bear with me... Here is what i am trying to do: Market rent = 1200.00 Current rent = 1170.00. I want to have a formula that takes the current rent, adds 3% if below market rent without going over market rent. If the sum of current rent+3% is over market rent then it calculates at 2.5% or brings the current rent to market rent unless it is equal to more than 3%. Here is the formula I'm using =IF(G50<F50,ROUNDUP(G50*0.03,2)+G50) ?????(G50F50,ROUNDUP(G50*0.025,2)+G50) Not sure how to do this (??? unknown transition) Thanks in advance for any help you can give! Bryan |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Ugh!
Thanks for the feedback, Bryan.....I'm glad I could help.
*********** Regards, Ron XL2002, WinXP "Bryan" wrote: Awesome! Thank you so much.l That was much easier than what i had for a formula! "Ron Coderre" wrote: Try something like this: With these values in cells A1:C2 Market Current PctIncr 1200 1170 3% D1: NewRent D2: =MIN(B2*(1+C2),A2) That formula returns the lesser of CurrentRent+3% or Market Rent Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Bryan" wrote: Hi there, First time poster - please bear with me... Here is what i am trying to do: Market rent = 1200.00 Current rent = 1170.00. I want to have a formula that takes the current rent, adds 3% if below market rent without going over market rent. If the sum of current rent+3% is over market rent then it calculates at 2.5% or brings the current rent to market rent unless it is equal to more than 3%. Here is the formula I'm using =IF(G50<F50,ROUNDUP(G50*0.03,2)+G50) ?????(G50F50,ROUNDUP(G50*0.025,2)+G50) Not sure how to do this (??? unknown transition) Thanks in advance for any help you can give! Bryan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) | |||
IF FORMULAS | Excel Worksheet Functions |