Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help please.
I am trying to create a formula to calculate rental return if a property
manager is involved and charges a % of the rent. (48 Weeks) R21 S21 T21 U21 Rent Property Manager Y/N Property Managers% Rent per year 100 y 10% 4,800.00 I have the following formula at this stage. =IF(AND(S21="y",R21<"",T21<""),R21*T21*48,IF(OR( R21="N",),"",R21*48)) But as you can see the 'N' part of the forumula works fine, but I cannot understand how to complete the following equation 100-10%x48 (which = 4,320.00) to replace ,R21*T21*48, Any suggestions? Cheers Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help please.
"Scoober" wrote:
=IF(AND(S21="y",R21<"",T21<""),R21*T21*48,IF(OR( R21="N",),"",R21*48)) But as you can see the 'N' part of the forumula works fine, but I cannot understand how to complete the following equation 100-10%x48 (which = 4,320.00) to replace ,R21*T21*48 If I understand you correctly, try: =IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(OR(R21="N",),"",R21*48)) Note: This assumes that T21 is the number 10% or 0.10, not something that simply appears that way. ----- original message ----- "Scoober" wrote in message ... I am trying to create a formula to calculate rental return if a property manager is involved and charges a % of the rent. (48 Weeks) R21 S21 T21 U21 Rent Property Manager Y/N Property Managers% Rent per year 100 y 10% 4,800.00 I have the following formula at this stage. =IF(AND(S21="y",R21<"",T21<""),R21*T21*48,IF(OR( R21="N",),"",R21*48)) But as you can see the 'N' part of the forumula works fine, but I cannot understand how to complete the following equation 100-10%x48 (which = 4,320.00) to replace ,R21*T21*48, Any suggestions? Cheers Scott |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help please.
Fantastic thanks!!
"JoeU2004" wrote: "Scoober" wrote: =IF(AND(S21="y",R21<"",T21<""),R21*T21*48,IF(OR( R21="N",),"",R21*48)) But as you can see the 'N' part of the forumula works fine, but I cannot understand how to complete the following equation 100-10%x48 (which = 4,320.00) to replace ,R21*T21*48 If I understand you correctly, try: =IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(OR(R21="N",),"",R21*48)) Note: This assumes that T21 is the number 10% or 0.10, not something that simply appears that way. ----- original message ----- "Scoober" wrote in message ... I am trying to create a formula to calculate rental return if a property manager is involved and charges a % of the rent. (48 Weeks) R21 S21 T21 U21 Rent Property Manager Y/N Property Managers% Rent per year 100 y 10% 4,800.00 I have the following formula at this stage. =IF(AND(S21="y",R21<"",T21<""),R21*T21*48,IF(OR( R21="N",),"",R21*48)) But as you can see the 'N' part of the forumula works fine, but I cannot understand how to complete the following equation 100-10%x48 (which = 4,320.00) to replace ,R21*T21*48, Any suggestions? Cheers Scott |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula help please.
Simplification....
I wrote: =IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(OR(R21="N",),"",R21*48)) First, I should have incorporated a correction to your original formula, namely: =IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(R21="N","",R21*48)) The OR function serves no useful purpose. Second, I suspect the following works just as well for you: =IF(R21="N","",R21*(1-T21)*48) This assumes that T21 is empty (not even "") when S21 is not "y" and R21 is not "N". Under those conditions, the formula evaluates to R21*(1-0)*48, which is R21*48, which is the same expression returned in your original formula under those conditions. And if T21 could be "", use the following: =IF(R21="N","",R21*(1-N(T21))*48) ----- original message ----- "JoeU2004" wrote in message ... "Scoober" wrote: =IF(AND(S21="y",R21<"",T21<""),R21*T21*48,IF(OR( R21="N",),"",R21*48)) But as you can see the 'N' part of the forumula works fine, but I cannot understand how to complete the following equation 100-10%x48 (which = 4,320.00) to replace ,R21*T21*48 If I understand you correctly, try: =IF(AND(S21="y",R21<"",T21<""),R21*(1-T21)*48,IF(OR(R21="N",),"",R21*48)) Note: This assumes that T21 is the number 10% or 0.10, not something that simply appears that way. ----- original message ----- "Scoober" wrote in message ... I am trying to create a formula to calculate rental return if a property manager is involved and charges a % of the rent. (48 Weeks) R21 S21 T21 U21 Rent Property Manager Y/N Property Managers% Rent per year 100 y 10% 4,800.00 I have the following formula at this stage. =IF(AND(S21="y",R21<"",T21<""),R21*T21*48,IF(OR( R21="N",),"",R21*48)) But as you can see the 'N' part of the forumula works fine, but I cannot understand how to complete the following equation 100-10%x48 (which = 4,320.00) to replace ,R21*T21*48, Any suggestions? Cheers Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|