If function not working

[Sarah28]

Hi



My if function is not working in column w


I need the formula to depend on the words “ money in” and “money out” . Just not sure why my IF function is not working

If money out = cell t5 , then t5 is negative , and if money in= cell u5 , u5 is positive . What happens in column w depends on whether the criteria is “money out” or “money in”

Can you assist?

 

[etaf]

I'm really not understanding the example and your comments

I need the formula to depend on the words “ money in” and “money out” . Just not sure why my IF function is not working

You have both in the same row Q & R

I'm guessing
T = debit - money out
U = credit - money in

then you could just multiple column T by -1

so in a new column put =T5*-1
copy down
now you have a new debit column

then you cna use that new column to do whatever you need

as i say - the text does not make sense to the image for me

Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.

Therefore -

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

you say
Q5=T5
which it wont, as on is text and the other values

U just has values in your example

do you mean S for money IN
the rows both have money in and money out , so no idea what you are after

 

[Sarah28]

I have come up with two separate functions need then combined in Cell W5


Formula 1 for “money out”


=If ( ISNUMBER(SEARCH(“Money Out”,Q5)>0,
-T5,””)

Formula 2 for “money in”

If(isnumber(search (“Money In”, R5)>0,U5,””)

Can you let me know how to combine the formulas

 

[p45cal]

cross posted without links:

Can I use sumif and if function together

Hi I have the following data Column a Column b Column c Debit. Credit Journal 1 - 200 I have a table as follows on the same spreadsheet Journal 1 Sumif(column a ,“journal 1”, column b) However, as you can see there is no value in...

www.mrexcel.com

@Sarah28 , for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of https://excelguru.ca/a-message-to-forum-cross-posters/

 

[Sarah28]

Okay , but can my formulas be combined. If not, why?

 

[p45cal]

=IF(ISNUMBER(SEARCH("Money Out",Q5)),-T5,IF(ISNUMBER(SEARCH("Money In",R5)),U5,""))

but note that if Q5 contains Money Out AND R5 also contains Money In that it will assume Money out.