# Thread: Struggling with an IF Function

1. ## Struggling with an IF Function

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.

2. You just need to divide the result by 100.

=IF(F2="No","*",(IF(C2>=1,(A2/B2*100-10.1),(A2/B2*100))/100))

3. Thanks very much!

Just me being a clown then.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•