Solved: Help with Formula's Excel 2007

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.

irvinbang

Thread Starter
Joined
Jan 25, 2013
Messages
85
If i have a Formula in A1 that says =IF(B1>0,C1,"")

Now lets say that when it calculates in A1 what ever is in B1 when C1 is greater than 0.

Now A1 has the number .8 from the calculation, but it needs to be at least 2. (No matter what the number is it always has to be at least 2.

How do i have the formula state that in A1 if there is a number under 2 that it will replace that number with 2. So if after you put in a number to B1 and it gives you anything under the number 2 in A1 it will replace that number and have a 2 there.

So the number in A1 no matter what the calculation will never go below the number 2.

Thanks in advance for the help.
 

Attachments

cwwozniak

Chuck
Moderator
Joined
Nov 28, 2005
Messages
68,404
If i have a Formula in A1 that says =IF(B1>0,C1,"")

Now lets say that when it calculates in A1 what ever is in B1 when C1 is greater than 0.
I think you have something backwards. The formula you gave checks if the contents of B1, not C1, is greater than 0. If that is true, then A1 is equal to the contents of C1, not B1.

After looking at your formula in your attached file, see if this formula will give you the desired results:
Code:
=IF(B1>0,MAX(C1,2),"")
 

irvinbang

Thread Starter
Joined
Jan 25, 2013
Messages
85
So now just a question how would i be able to input the ,Max if i had a formula like:

=IF(SUM(U11,U12,U13,U14)=0,"",SUM(U11,U12,U13,U14))

If I needed the Max number to be 3.
 

cwwozniak

Chuck
Moderator
Joined
Nov 28, 2005
Messages
68,404
If I needed the Max number to be 3.
Do you mean that the maximum number to be returned is the lesser of 3 or SUM(U11,U12,U13,U14)? If so, the formula would be:
Code:
=IF(SUM(U11,U12,U13,U14)=0,"",MIN(3,SUM(U11,U12,U13,U14)))
 
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!

Top