# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Need assistance with if / or statement where result is calculating backwards
Solved by S. U. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/09/2017 - 03:23
Welcome to Go it Pro-Excel
Excelchat Expert 24/09/2017 - 03:23
User 24/09/2017 - 03:24
have a few conditional formulas that i cannot seem to make work and i think that it is because they are all based off other calculated cells?
Excelchat Expert 24/09/2017 - 03:24
OK, can you show me how you are trying to do it?
User 24/09/2017 - 03:24
can see what i just pasted
Excelchat Expert 24/09/2017 - 03:25
Column P is the formula?
User 24/09/2017 - 03:25
lots of formulas - can i only get help on one
Excelchat Expert 24/09/2017 - 03:26
Ok i can not see the formula in this document
User 24/09/2017 - 03:26
i need the minimum of F, I, L - unless it is 0
User 24/09/2017 - 03:27
I want it to show the number bigger
Excelchat Expert 24/09/2017 - 03:27
Ok
User 24/09/2017 - 03:27
so in this example It would be 296.43
Excelchat Expert 24/09/2017 - 03:27
why you don't use the Max function
Excelchat Expert 24/09/2017 - 03:27
User 24/09/2017 - 03:27
because it could be that there would be a larger number there as well
Excelchat Expert 24/09/2017 - 03:28
=max(F2,I2,L2)
User 24/09/2017 - 03:28
i would not want 5000
User 24/09/2017 - 03:28
I would still want 296.43
User 24/09/2017 - 03:28
not 0
Excelchat Expert 24/09/2017 - 03:29
Ok
Excelchat Expert 24/09/2017 - 03:30
OK you want the minimum different than 0
User 24/09/2017 - 03:30
yes
Excelchat Expert 24/09/2017 - 03:30
And the maximum from where?
User 24/09/2017 - 03:31
no maix
Excelchat Expert 24/09/2017 - 03:31
OK
Excelchat Expert 24/09/2017 - 03:31
Do you want to see what is wrong with your formula or do you want me to create a new one?
User 24/09/2017 - 03:31
just fix it
User 24/09/2017 - 03:32
in N
Excelchat Expert 24/09/2017 - 03:32
ok, but it is not formula in N, just a number
User 24/09/2017 - 03:32
I know -
User 24/09/2017 - 03:33
that is where it goes tho
Excelchat Expert 24/09/2017 - 03:33
ok
Excelchat Expert 24/09/2017 - 03:33
got it
Excelchat Expert 24/09/2017 - 03:34
Min between quote #1, #2 and #3
Excelchat Expert 24/09/2017 - 03:34
right?
Excelchat Expert 24/09/2017 - 03:34
different than 0
User 24/09/2017 - 03:34
yess
Excelchat Expert 24/09/2017 - 03:35
OK
Excelchat Expert 24/09/2017 - 03:35
Im working with you
User 24/09/2017 - 03:35
Thanks - was a typo
Excelchat Expert 24/09/2017 - 03:37
Ok I got i quick solution
User 24/09/2017 - 03:37
Great
Excelchat Expert 24/09/2017 - 03:37
but is not supported in excel online
User 24/09/2017 - 03:37
hummm
Excelchat Expert 24/09/2017 - 03:37
Is an array formula
Excelchat Expert 24/09/2017 - 03:37
the other one is with If Function
Excelchat Expert 24/09/2017 - 03:38
im going to give you both
User 24/09/2017 - 03:38
I tried If - didnt work
User 24/09/2017 - 03:38
thanks
Excelchat Expert 24/09/2017 - 03:38
I gonna give you If over here
User 24/09/2017 - 03:38
ok
Excelchat Expert 24/09/2017 - 03:38
and you can try the other way in excel
User 24/09/2017 - 03:38
ok
Excelchat Expert 24/09/2017 - 03:43
Im working
Excelchat Expert 24/09/2017 - 03:43
let me fix something
User 24/09/2017 - 03:44
ok
Excelchat Expert 24/09/2017 - 03:45
=IF(AND(E2<>0,E2<H2,E2<K2),E2,IF(AND(H2<>0,H2<K2),H2,IF(K2<>0,K2,H2)))
Excelchat Expert 24/09/2017 - 03:45
OK here is with the If Function
User 24/09/2017 - 03:46
seems to work in my spreadsheet
User 24/09/2017 - 03:46
Thanks
Excelchat Expert 24/09/2017 - 03:46
You are welcome!
Excelchat Expert 24/09/2017 - 03:47
Entering to explanation Phase
Excelchat Expert 24/09/2017 - 03:48
I compare the first value the others if it is different than 0 and less than the others so this is the number, if not it move to the second nnumber
Excelchat Expert 24/09/2017 - 03:49
and later to the Third
User 24/09/2017 - 03:49
I understand completely now that i see it. Can i ask about another one
Excelchat Expert 24/09/2017 - 03:50
You need to create another session, but go ahead. we have time
User 24/09/2017 - 03:51
thanks
User 24/09/2017 - 03:52
ok - so - in PURCHASE PP
User 24/09/2017 - 03:52
I need it to say "PURCHASE" if
User 24/09/2017 - 03:52
savings \$\$ amount is over \$125 or Savings % is over 25%
User 24/09/2017 - 03:53
otherwise it should be blank
Excelchat Expert 24/09/2017 - 03:54
=IF(OR(O2>125,P2>25),"PURCHASE","")
Excelchat Expert 24/09/2017 - 03:54
that formula does not include 125 and 25%
Excelchat Expert 24/09/2017 - 03:54
=IF(OR(O2>125,P2>0.25),"PURCHASE","")
Excelchat Expert 24/09/2017 - 03:54
sorry i forgot the 0.25
User 24/09/2017 - 03:55
Yes - that is exactly what i have in my spreadsheet - however - it only says purchase if the numbers are negitive and my signs are not backward
User 24/09/2017 - 03:55
s
Excelchat Expert 24/09/2017 - 03:56
Maybe you have "<" sing instead of ">"
Excelchat Expert 24/09/2017 - 03:57
How can you have negative numbers in savings?
Excelchat Expert 24/09/2017 - 03:58
The formula works for numbers higher than 125 and negative numbers are not higher than that
Excelchat Expert 24/09/2017 - 03:58
Entering to Discussion Phase
User 24/09/2017 - 03:58
right - but if the lowest quote is higher than the original quoted amount it creates a negative number
Excelchat Expert 24/09/2017 - 03:58
OK, got it
Excelchat Expert 24/09/2017 - 03:59
it Make sense
User 24/09/2017 - 03:59
so is it possible it is doing this because it is figuring off of calculated fields
Excelchat Expert 24/09/2017 - 04:00
Ummm
Excelchat Expert 24/09/2017 - 04:01
I should know better what is Quote 1 and original to help you better
Excelchat Expert 24/09/2017 - 04:01
User 24/09/2017 - 04:01
I know - thnaks for your help
Excelchat Expert 24/09/2017 - 04:01
It Was my pleasure!
Excelchat Expert 24/09/2017 - 04:01
Have a nice day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.