Mutiple IF Functions

[Farmer643]

Friends

Is it possible to do add two un related if functions together. By that I mean

Function 1
Produced a result x based on certain criteria. If you don't get X you get 0

Function 2
Produces a result y based on certain different criteria. If you don't get Y you get 0

In circumstances where you get X and Y I'd like to add those together to get Z

All help greatly received!

Farmer

[MarvinP]

Hi Farmer643,

Sounds like it is very possible with Excel. If you can supply an example we can show you how this might fit together.

Read some examples at: https://www.educba.com/multiple-ifs-in-excel/

[Farmer643]

How best do I do that?

My formula at the moment is

=if(K5=$G$15,-$E$29+-$F$29,IF(K5<$G$15,-$G$29/12,0))

and what I want to do is add the result of that to

=if(K5>$Q$5<$T$5,$H$29/12,0)

[Farmer643]

Thanks a million...

[JeteMc]

I can not use K5>$Q$5<$T$5 as a logical test in the 2019 version so I would suggest the following:

Please Login or Register  to view this content.

Let us know if you have any questions.