IF OR Function Help Please

[Nicki1978]

Hi All,

I'm new and was hoping someone maybe able to help me with this one please.

I understand the very basic IF function and that's my limit unfortunately. I am trying to insert an IF OR function (if that is what I need for this scenario for the "Funds at the end of the year"

I have:

Total Receipts: £28.00
Total Payment: £140.50

Increase in funds this year: £
Decrease in funds this year: -£112.50

Funds at the start of the year: £1,100.17
Funds at the end of the year: [trying to insert formula here to take into account one of the figures in italics above]


I have come up with the following;

=IF(E38>0,E41+E38,"")*OR(IF(E39<0,E41+E39))

but it is resulting in #VALUE!

Please could someone tell me where I am going wrong.

Thank you so much in advance. Nic

[Crooza]

I think what you want is

=IF(E38>0,E41+E38,E41+E39)

[Richard Buttrey]

Hi,

If only one of E38 or E39 contain a number with the other being zero then you don't need an IF statement

+E41+E38+E39

will suffice.

Incidentally next time uoload the workbook. This helps us all when we can see the request in context.

[Nicki1978]

Many thanks for your reply Crooza.

I did try that initially as that made sense to me, but it still returns a result of #VALUE!.

It only seems to work if the Receipts are more than the Payments. That's why I thought maybe I needed an OR function in it.

[Crooza]

I'd say you've got spaces in the fields then ie they are not blank. Upload a file like Richard said above and someone will check it out

[Nicki1978]

Oh my goodness, thank you Richard , why did I not think of this. I think I was certainly overthinking the matter.

Thanks once again for your help.

Also, thank you for your advice re uploading the workbook next time

[Nicki1978]

I have a attached a worksheet from the workbook I'm currently using and I've entered the formula's you have provided and the results it shows.

I'm not sure why I can only get the AutoSum option to work and wondered if it was something I'm missing.

if_or_function.xlsx

Many thanks. Nic

[JohnTopley]

In D34

=IF(D13>D32,D13-D32,0)

0 instead of ""

[Nicki1978]

Great, thanks John; that now works with the IF function.

That now makes sense as technically in D34 it was returning a "nothing" result rather than a 0, which my subsequent IF function was relying on a result of 0 rather than nothing

[Nicki1978]

Thanks for all of your help and I will remember to include worksheet/books next time

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.