Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
newbie
I need a formula to: If 'B8' 80% then 'C3' * .63% and / that by 12, if 'B8'
is 85.01%, * 'C3' by .86% and / that by 12, etc. Please help with example. -- lena |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
newbie
Hi,
Try this =if(and(b8<=0.8501,b80.80),C3*0.0063/12,C3*0.0086/12,0) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "lena" wrote in message ... I need a formula to: If 'B8' 80% then 'C3' * .63% and / that by 12, if 'B8' is 85.01%, * 'C3' by .86% and / that by 12, etc. Please help with example. -- lena |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
newbie
Your IF conditions are not consistent (or at least I couldn't understand).
Please verify them and post again. -- R. Khoshravan Please click "Yes" if it is helpful. "lena" wrote: I need a formula to: If 'B8' 80% then 'C3' * .63% and / that by 12, if 'B8' is 85.01%, What is the condition for this part: * 'C3' by .86% and / that by 12, etc. Please help with example. -- lena |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
newbie
On Feb 5, 3:00*pm, lena wrote:
I need a formula to: *If 'B8' 80% then 'C3' * .63% and / that by 12, if 'B8' is 85.01%, * 'C3' by .86% and / that by 12, etc. *Please help with example. Well, for what you specify, you could do simply: =if(B8 85.01%, C3*0.86%/12, if(B8 80%, C3*0.63%/12, "")) Note that I added a 3rd result: "" (null string). The point is: what do you want if B8<=80%? Replace "" with whatever you want. Moreover, if all results can be express as "C3 times some percent, then divided by 12", you can simplify the expression in any of a number of ways. One way: =C3 * if(B8 85.01%, 0.86%, if(B8 80%, 0.63%, 50%)) / 12 where I substituted "" with 50% arbitrarily. One last comment, if I may: comparing with numbers like 85.01% -- even 80% -- is dubious because such numbers are rarely stored internally exactly as they are displayed in a cell. I suspect you would be happier if you write: =C3 * if(round(B8,4) 85.01%, 0.86%, if(round(b8,2)80%, 0.63%, 50%)) / 12 and perhaps you want the second ROUND to be to 4 dp, too. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
newbie
lena wrote:
I need a formula to: If 'B8' 80% then 'C3' * .63% and / that by 12, if 'B8' is 85.01%, * 'C3' by .86% and / that by 12, etc. Please help with example. The "etc." in your post suggests more variables. If there are many, a standard IF() formula may not work. Post your entire requirement to get a proper solution. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
newbie
On Feb 6, 6:05*am, Glenn wrote:
lena wrote: I need a formula to: *If 'B8' 80% then 'C3' * .63% and / that by 12, if 'B8' is 85.01%, * 'C3' by .86% and / that by 12, etc. *Please help with example. The "etc." in your post suggests more variables. *If there are many, a standard IF() formula may not work. *Post your entire requirement to get a proper solution. Good eye! I missed that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help Newbie | Excel Worksheet Functions | |||
NEWBIE | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
newbie needs help | Charts and Charting in Excel | |||
JET dB Newbie Needs Help | Excel Discussion (Misc queries) |