I would like a formula to execute an answer from a cell only if the cell is equal to or greater than a certain number, for example:
If the answer of E1= A1*B1*C1/D1 is LESS than 40 I would want G1= D1*F1 and if it is EQUAL TO or GREATER than 40 I would want I1=D1*H1
LESS THAN EXAMPLE: 4(A1)X4(B1)X8(C1)/128(D1)=1(E1)X$16.00(F1)=G1
GREATER THAN EXAMPLE 40(A1)*40(B1)*80(C1)/128(D1)=1000(F1)*$14.00
Something like this, maybe...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Awesome, Thank you!is there a way to make =IF(E1>=40,D1*H1,"")ONLY GO UP TO >150
If I understand correctly, How about
=IF(E1>=40,MIN(D1*H1,150),"")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi treatedwood. I'm sure the answer is yes; but I don't quite understand your question. Can you explain again?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks