Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |