IF function woes
Hi there,
I'm analysing some metabolomic data on excel due to the vast amounts of data I have.
I'm trying to identify fold change and incorporating the IF function.
Eg If T2-O2/0.244 is less than 0, I want 0 to appear and not a negative number.
Seems simple and I've tried many functions but I still seem to get the odd negative number.
Many thanks in adavance!!
Use MAX(0,T2-O2/0.244) or probably what you want is MAX(0,(T2-O2)/0.244)
Life's a spreadsheet, Excel!
Say thanks, Click *
Try This it may help
ACE-XL, formula, gives your result but as you mentioned that you tried many formulae, look and this one, using just if function.
=IF(T2-O2/0.244<0,0,T2-O2/0.244)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks