Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I am currently working on an IF statement and hoped someone with more advanced knowledge would help me out:
<o> </o>
I have included details for row 8
<o> </o>
Cell AL8 = No
Cell AM8 = Y
<o> </o>
Cell AN8 = NoY (combination of AL8& AM8)
<o> </o>
Cell AO8 = A percentage e.g. 75%
<o> </o>
I want cell AP8 to return the following details:
<o> </o>
IF cell AN8 equals NoY AP8 should give me the % in cell AO8
However, if Cell AN8 equals NoN it should return the value as 0%
Any Help would be greatly appreciated.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I am currently working on an IF statement and hoped someone with more advanced knowledge would help me out:
<o
> </o>I have included details for row 8
<o
> </o>Cell AL8 = No
Cell AM8 = Y
<o
> </o>Cell AN8 = NoY (combination of AL8& AM8)
<o
> </o>Cell AO8 = A percentage e.g. 75%
<o
> </o>I want cell AP8 to return the following details:
<o
> </o>IF cell AN8 equals NoY AP8 should give me the % in cell AO8
However, if Cell AN8 equals NoN it should return the value as 0%
Any Help would be greatly appreciated.
