Microsoft Office Questions? Ask a IT Expert for Support ASAP
this is weird when I do it alone it works but when I put it in the form
it dont work it just gives me a false reading ""
A2 = 5140
H2 = 500
C2 = 700
the outcome should be 50
I get ""
the formula is in f3
the file you sent back says
whats = iferror
also if I change the truck # XXXXX formula don't change anything?
Ken,Sorry for the confusion, but the logic should be AND because it is inclusive. That is, A3 MUST BE greater that 5000 but less than 5999. If it is an OR, if the truck number is XXXXX it must be false, but the OR formula gives a TRUE because A3Here is the formula:=IFERROR(IF(AND(A3>5000,A3<5999),(E3+500)-C3,""),"")IFERROR means, if the result is an error, it will show "" (blank). If there is no error, it will show the results of the formula.Here is the formula with NO iferror encapsulation:=IF(AND(A3>5000,A3<5999),(E3+500)-C3,"")The problem WHY the results are not displayed is because the numbers in the truck # XXXXX is set to TEXT, not numbers. I changed them to number format so it works now.Download here:http://wikisend.com/download/102574/Book4_rev2.xlsxPlease remember to rate my service positively (3-5 stars/faces) once you have all the information you need. Tips are always highly appreciated! If you have any other questions, please ask me or reply to me – I’ll be happy to respond. Thank you!Best regards,Jess