Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Addition help to edit a formula
Hi,
I need to edit a formula and don't really know how to do it. This was made by another person which is no longer here. I'll try my best to explain what it does. This forumla interacts with 9 other cells, the default setting in column C is: XxxxxX###_xxxx_XXXxxxxx where column C = Column D # is an ID number. For example F0705V363_GML_MagAPACS Column D =CONCATENATE(E#,F#,G#,H#,L#,I#,L#,J#,K#) # is the row number Column E =IF(AZ#="—‹", IF(BA#="-","F","B"),IF(BA#="—‹","I","X")) Column F =IF(S#0, CONCATENATE(0,LEFT(S#,3)),"xxxx") Column G =IF(AF#="A","A",IF(AF#="V","V","X")) Column H =B# Column I =IF(ISBLANK(AG#)=TRUE,"xxxx",AG#) Column J =IF(ISBLANK(AM#)=TRUE,"xxx",LEFT(AM#,3)) Column K =IF(ISBLANK(AP#)=TRUE,"xxxxx"Left(AP#,5)) Column L =_ Column B has ID numbers in it. Now what I need to do is add Column AX in this formula that takes values from both AX and AF. When AX has value of 1.1 and AF has either A or V, I need Column E to respond with a 1F or 1B, instead of just F or B. But when AX has value of 1.0, I need F or B returned. Roger Govier was kind enough to suggest this formula: =IF(AND(AX8=1.1,OR(AF8="A",AF8="V")),"1"&IF(AZ8="? ", IF(BA8="-","F","B"),IF(BA8="?","I","X")),"") It works fine if I have AX value of 1.1, but when I have value 1.0, I loose my F or B. I tried to understand how this works, but unfortunately I don't. So if anyone can help me, please do and I thank anyone that willing to take a look at this. I hope I explained this well enough. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Addition Formula | Excel Worksheet Functions | |||
Formula Addition Copy | Excel Discussion (Misc queries) | |||
Progressive Addition Formula | Excel Worksheet Functions | |||
addition to my date formula...required | Excel Worksheet Functions | |||
help with simple addition formula | Excel Worksheet Functions |