Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am having a lot of trouble with an if, then statement. Here is what I have:
In the following cells I will have a number Q9, R9, S9 In T9 I am wanting it to calculate the following: If S9=0, then it should automatically equal 00.00%, otherwise If R9=0, and Q90, thenit should equal (100%), if this statement is false, then it should equal 100%, otherwise If R<0, then S9/R9 This is the function I entered: =IF($S9=0,"00.00%",if(and($r9=0,$q90),"(100%)","1 00%",if($r9<0,$S9/$R9))) We are working on these very detailed reports and this is something our supervisor asked us to work on. I'm not sure if this can even be done, but I am stuck at this point. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statements | New Users to Excel | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
How can I add IF statements | Excel Worksheet Functions | |||
If Statements... | Excel Discussion (Misc queries) | |||
Add two IF statements together | Excel Worksheet Functions |