How to combine two IF(S) statements?

Greetings All, I have been trying to sort out for days and am missing something

=IF(F10="Per Metre",(E10/3.2808399)*H5) This works great as expected.

=IFS(F10="Each",E10/6)*H5 This works great as well.

How do i combine the 2 together

Any help would be great thanks

Please make answers simple.

Like this, perhaps

=IF(F10="Per Metre",(E10/3.2808399)*H5,(E10/6)*H5)

Administrative Note:

Your thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you have so few posts here, I have done it for you this time, but would urge you to read our rules!.)

What if F10 is not either of those values?

Then this:

=IF(F10="Per Metre",(E10/3.2808399)*H5,IF(F10="Each",(E10/6)*H5,""))

The "" can be replaced with anything the OP likes.

Sorry, that was not aimed at you, but at the OP.

No, but you were right to ask and I've offered a solution.

This has been posted to my visitor message feed (should have been posted here):

Greetings.
Thanks for that, now i see it as there are only 2 choices i believe.
would you be so kind as to ( for future reference ) explain if there were three choices.

=IFS(F10="Per Metre",E10/3.2808399)*H5
=IFS(F10="Each",E10/6)*H5
=IFS(F10="Per Qube",E10/6)*H5

Try this:

=IF(F10="Per Metre",(E10/3.2808399)*H5,IF(F10="Each",(E10/6)*H5,IF(F10="Per Qube",(E10/6)*H5,"")))

Given that only one factor appears to change, and still dependent on whether F10 might not contain any of the values in question, one could also use something like:

=(E10/IF(F10="Per Metre",3.2808399,6))*H5

Yes, I agree completely, but I think the OP needs to understand the principle of nesting IF statements.

I would have done it differently (in a similar way to you, Rory).

Alan - thanks for your PM. I have sent you a message explaining how to reply to this thread (by typing into the Quick Reply box below) - please do this now, and then I will explain (here) how to sign off the thread.

I feel I must apologise on Alan's behalf for his not coming back and signing off. I have sent him the information he needs to post to this thread, but he has now left, so knowing that he feels the issue is resolved, I am going to mark this as solved for him.

@Alan

If you post here again, please follow my instructions and keep the converstaion within your thread. Don't use visitor messages and private messages instead. Thanks.

Thanks, Alan, and glad you managed to post here finally!!!