Need a formula to the following please:
IF A1 is greater than 0 and less than 7, then return the result in A1
IF A1 is equal or greater than 7, then return 7
IF A1 is equal or less than 0, then return nothing
IF A1 is empty then return nothing.
Thanks
Last edited by halfpint123; 09-28-2012 at 11:53 AM.
What do you mean by this?..iF A1 is greater than 0 and less than 7, then return the result in A1
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
not sure what you're waiting to get if A1 is 0 or 7
An attempt
Please Login or Register to view this content.
Cheers
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
=if(or(a1="",a1<0),"",if(a1>7,7,a1))
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi,
not sure what you're waiting to get if A1 is 0 or 7
An attempt
Please Login or Register to view this content.
Cheers
Corrected what I want. Please help
give the figure in A1.
So for instance if 8 is A1, the formula would return 7.
If 6 is A1 the formula would return 6.
My suggestion.
=IF(OR(A1=0,A1=""),"",IF(A1>7,7,IF(AND(A1>0,A1<=7),A1)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks