Solved: Two separate formula conditions in one cell

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

mmdmalta

Thread Starter
Joined
Apr 21, 2015
Messages
10
Hello i am trying to figure out how to have to formulas (or conditions) in one cell. For example I have a cell where i want to have one condition insert 7%, and one condition to insert 5%. The current formula i have now is

=IF(O198<1+O198,7%), but i also want the column p198 to be 5%, and i want the formula in the Q cell. (if cell o198 is greater than 1.00 i want it to insert 7% in column Q, if P cell is than 1.00 i want it to insert 5% in the Q cell. Both columns will not have a dollar amount, only one or the other.

Please advise, i'm pulling my hair out. I know the first formula is correct, but how do i get the second half of it.

Thank you

mmdmalta
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,471
Try

=IF( O198 > 1 , 0.07, 0.05 )

if you want = 1 or greater

=IF( O198 >= 1 , 0.07, 0.05 )
 

mmdmalta

Thread Starter
Joined
Apr 21, 2015
Messages
10
Hi Wayne,

That still didn't not work. It return 7% in the Q cell, but when I tried to enter the total that i wanted in the other cell so that it would read 5% it just returned 7%. Any other suggestions.

MMDmalta
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,471
not without see a sample sheet - so i can fully understand what is being entered

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
 

mmdmalta

Thread Starter
Joined
Apr 21, 2015
Messages
10
ok, how do i download it to this post. Can't find an icon or anything indicating attaching a file?
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,471
To upload to the forum, open the full reply window ("Go Advanced" button) and use the Manage Attachments button to upload it here.
 

mmdmalta

Thread Starter
Joined
Apr 21, 2015
Messages
10
Ok Wayne,

Attached is the section of the workbook (everything else i removed for privacy) It's pretty self explanatory once you open it up. But basically I want column "Q" to automatically insert either 5% or 7%. If i put any $ amount in column "O" (new monthly), then I want cell "Q" to read 7%. If i enter any $ amount in Column "P", (recurring monthly), then I want it to read 5%. I hope that is a better explaination.

mmdmalta
 

Attachments

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,471
will O and P be a zero if the other column is used

IE
O will be zero and P have a value
P will be zero and O have a value

The rules seem to have changed

you say
If i put any $ amount in column "O" (new monthly), then I want cell "Q" to read 7%. If i enter any $ amount in Column "P", (recurring monthly), then I want it to read 5%.
BUT before you mentioned a Value of >1 and <1 for the 7 and 5%

=IF( O198>0 , 0.07, IF( P198>0, 0.05, "O and P is zero"))

if you want a zero or blank if no entry made then change "O and P is zero" to a 0 for zero and "" for a blank

see attached using 0
 

Attachments

mmdmalta

Thread Starter
Joined
Apr 21, 2015
Messages
10
i'm sorry, i may have confused you. Yes.... O and P be a zero if the other column is used. I didn't know how else to do it, so i used less than 1. But that is correct. If O is used then P will have a zero. If P is used than O will have a zero.
 

mmdmalta

Thread Starter
Joined
Apr 21, 2015
Messages
10
Thank you Wayne. It worked!!!! you are a genius!! I will make sure i recommend you!! Thanks again.
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,471
your welcome (y) thanks for letting us know
You can mark your own threads solved using the
button at the top of the page of the thread in the upper left corner.
:)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top