Hi Guys,
New to the forum and I'm having some difficulties with an IF forumula that no matter what I try I can't get my head round. I think it's because I'm trying to join 2 seperate IF statements into one formula.
I've got 3 values, A, B and C.
I want the formula to look at Cell F2 and if it says "No" to display "*" in the cell. If it doesn't say "No" it'll carry out the following formula:
IF C >=1 then A/B*100-10.1 to display as a %
However
IF C=0 then A/B * 100
I've tried the following (also attached):
=IF(F2="No","*",(IF(C2>=1,(A2/B2*100-10.1),(A2/B2*100))))
I think I'm sort of close as it does what I want it to do but it's displaying the results as 8323.33% which I obviously don't want for a %. The actual answer should be 83.23%.
Any help greatly appreciated.
Thanks.
New to the forum and I'm having some difficulties with an IF forumula that no matter what I try I can't get my head round. I think it's because I'm trying to join 2 seperate IF statements into one formula.
I've got 3 values, A, B and C.
I want the formula to look at Cell F2 and if it says "No" to display "*" in the cell. If it doesn't say "No" it'll carry out the following formula:
IF C >=1 then A/B*100-10.1 to display as a %
However
IF C=0 then A/B * 100
I've tried the following (also attached):
=IF(F2="No","*",(IF(C2>=1,(A2/B2*100-10.1),(A2/B2*100))))
I think I'm sort of close as it does what I want it to do but it's displaying the results as 8323.33% which I obviously don't want for a %. The actual answer should be 83.23%.
Any help greatly appreciated.
Thanks.