Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel "IF" functions
Hello,
I am trying to create an "IF" formula to indicate an "X" in a cell if the following criteria is met: 10% of entity's Total Assets(C11) and .05% total variance (between two periods) and any variances over $500K Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel "IF" functions
An example would have helped a lot.
What do we compare 10% of total assets to? How do you calculate variance? Do you meant .05% variance, or 5% variance? When you say 500K, do you mean 500000? When you say "and" do you mean *all* criteria must be met, or any one of them? Regards, Fred "Katrina" wrote in message ... Hello, I am trying to create an "IF" formula to indicate an "X" in a cell if the following criteria is met: 10% of entity's Total Assets(C11) and .05% total variance (between two periods) and any variances over $500K Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions |